metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA695273" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA695273" and tax_clade = "PVC group"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
3227638	3227638	PRJNA695273_P_NODE_121503_length_255_cov_1.329670_g120745_i0	PRJNA695273	121503	255	1.32967	3.3906585	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	409	1.19e-109	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g120745	i0	95.686	1.22352941176471	255	10	100	1	1	255	4510425	4510678	Planctomyces sp. SH-PL14, complete genome	blastn	312	409	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
5782252	5782252	PRJNA695273_P_NODE_73145_length_323_cov_0.784000_g72387_i0	PRJNA695273	73145	323	0.784	2.53232	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	78.7	5e-10	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g72387	i0	91.525	0.359133126934985	59	1	18	4	142	199	62962	62907	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	116	78.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
7055303	7055303	PRJNA695273_P_NODE_124226_length_252_cov_0.748603_g123468_i0	PRJNA695273	124226	252	0.748603	1.88647956	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	322	1.58e-83	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g123468	i0	91.561	118.793650793651	237	15	93	5	16	250	1830976	1830743	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	29936	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
9605020	9605020	PRJNA695273_P_NODE_117328_length_260_cov_1.272727_g116570_i0	PRJNA695273	117328	260	1.272727	3.3090902	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	276	1.29e-69	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g116570	i0	86.22	1.40384615384615	254	35	98	0	1	254	4779500	4779247	Planctomyces sp. SH-PL62, complete genome	blastn	365	276	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
10880297	10880297	PRJNA695273_P_NODE_104909_length_274_cov_1.532338_g104151_i0	PRJNA695273	104909	274	1.532338	4.19860612	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	73.1	1.93e-8	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g104151	i0	95.556	8.0985401459854	45	2	16	0	71	115	1007378	1007422	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	2219	73.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
10880844	10880844	PRJNA695273_P_NODE_128049_length_250_cov_1.587571_g127291_i0	PRJNA695273	128049	250	1.587571	3.9689275	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	156	1.68e-33	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g127291	i0	78.75	4	240	45	94	3	12	245	622969	623208	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	1000	156	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
10881034	10881034	PRJNA695273_P_NODE_135749_length_248_cov_0.880000_g134991_i0	PRJNA695273	135749	248	0.88	2.1824	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	226	1.2499999999999999e-54	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g134991	i0	83.265	0.987903225806452	245	41	99	0	1	245	2415554	2415798	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	245	226	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
12155775	12155775	PRJNA695273_P_NODE_119370_length_257_cov_2.396739_g118612_i0	PRJNA695273	119370	257	2.396739	6.15961923	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	418	1.9999999999999994e-112	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g118612	i0	97.166	317.252918287938	247	7	96	0	1	247	2501352	2501106	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	81534	418	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
12156999	12156999	PRJNA695273_P_NODE_25370_length_548_cov_3.578947_g24617_i0	PRJNA695273	25370	548	3.578947	19.61262956	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	619	1.1799999999999997e-172	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g24617	i0	87.614	59.7883211678832	549	48	100	13	1	548	1831118	1831647	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	32764	619	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
13935672	13935672	PRJNA695273_P_NODE_108251_length_270_cov_1.908629_g107493_i0	PRJNA695273	108251	270	1.908629	5.1532983	Verrucomicrobiota	74201	Bacteria	Bacteria	344	3.65e-90	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g107493	i0	89.668	228.114814814815	271	26	100	2	1	270	2750497	2750228	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	61591	344	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15979030	15979030	PRJNA695273_P_NODE_106833_length_272_cov_1.386935_g106075_i0	PRJNA695273	106833	272	1.386935	3.7724632	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	270	6.329999999999999e-68	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g106075	i0	84.672	1.00735294117647	274	38	100	4	1	272	1400605	1400334	Luteolibacter sp. SL250 chromosome	blastn	274	270	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
15980122	15980122	PRJNA695273_P_NODE_155133_length_242_cov_1.473373_g154375_i0	PRJNA695273	155133	242	1.473373	3.56556266	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	398	2.4299999999999994e-106	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g154375	i0	97.046	37.8140495867769	237	6	98	1	1	237	2120063	2120298	Luteolibacter sp. SL250 chromosome	blastn	9151	398	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
17254602	17254602	PRJNA695273_P_NODE_124134_length_252_cov_1.189944_g123376_i0	PRJNA695273	124134	252	1.189944	2.99865888	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	154	6.09e-33	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g123376	i0	81.152	55.1746031746032	191	36	76	0	3	193	3194731	3194921	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	13904	154	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
17255050	17255050	PRJNA695273_P_NODE_142434_length_246_cov_0.890173_g141676_i0	PRJNA695273	142434	246	0.890173	2.18982558	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	241	4.42e-59	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g141676	i0	84.711	10.1219512195122	242	35	98	2	2	242	5445625	5445385	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	2490	241	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
17759485	17759485	PRJNA695273_P_NODE_102174_length_277_cov_1.509804_g101416_i0	PRJNA695273	102174	277	1.509804	4.18215708	Gemmata	113	Bacteria	Bacteria	331	2.9200000000000002e-86	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g101416	i0	88.686	2.94584837545126	274	28	99	2	1	274	7965170	7965440	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	816	331	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
19033393	19033393	PRJNA695273_P_NODE_101475_length_278_cov_1.463415_g100717_i0	PRJNA695273	101475	278	1.463415	4.0682937	Frigoriglobus	2774146	Bacteria	Bacteria	102	2.51e-17	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g100717	i0	100	9.16906474820144	55	0	20	0	212	266	5501008	5501062	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	2549	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
22353761	22353761	PRJNA695273_P_NODE_111138_length_267_cov_1.525773_g110380_i0	PRJNA695273	111138	267	1.525773	4.07381391	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	300	7.9e-77	NTclustered	gi\|2874253793\|emb\|OY969777.1\|	412056	g110380	i0	87.891	48.5205992509363	256	29	96	2	12	266	2341541	2341795	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1	blastn	12955	300	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
25408330	25408330	PRJNA695273_P_NODE_117140_length_260_cov_1.604278_g116382_i0	PRJNA695273	117140	260	1.604278	4.1711228	Pseudomonadati	3379134	Bacteria	Bacteria	65.8	3.04e-6	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g116382	i0	91.489	0.338461538461538	47	4	18	0	182	228	294607	294653	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	88	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;