metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA745553" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA745553" and tax_phylum = "Verrucomicrobiota"

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
724029	724029	PRJNA745553_S_NODE_13301_length_337_cov_6.136364_g13106_i0	PRJNA745553	13301	337	6.136364	20.67954668	Luteolibacter sp.	1962973	Bacteria	Bacteria	257	6.28e-64	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g13106	i0	85.887	218.06824925816	248	27	74	7	25	267	1010074	1009830	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	73489	257	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
724209	724209	PRJNA745553_S_NODE_23781_length_253_cov_4.277778_g23586_i0	PRJNA745553	23781	253	4.277778	10.82277834	Pedosphaera parvula	1032527	Bacteria	Bacteria	196	1e-45	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g23586	i0	85.561	1.47826086956522	187	27	74	0	55	241	1053	867	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	374	196	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
3275727	3275727	PRJNA745553_S_NODE_6363_length_462_cov_9.347044_g6169_i0	PRJNA745553	6363	462	9.347044	43.18334328	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	719	0	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g6169	i0	94.816	173.525974025974	463	21	100	2	1	462	718	258	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	80169	719	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
4552843	4552843	PRJNA745553_S_NODE_29804_length_213_cov_4.371429_g29609_i0	PRJNA745553	29804	213	4.371429	9.31114377	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	335	1.6599999999999996e-87	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g29609	i0	98.421	103.028169014085	190	3	89	0	13	202	2556235	2556424	Lacunisphaera limnophila strain IG16b, complete genome	blastn	21945	335	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
7103075	7103075	PRJNA745553_S_NODE_5006_length_504_cov_3.069606_g4812_i0	PRJNA745553	5006	504	3.069606	15.47081424	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	789	0	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g4812	i0	95.893	63.8611111111111	487	20	97	0	18	504	3558048	3557562	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	32186	789	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
8377592	8377592	PRJNA745553_S_NODE_24527_length_250_cov_1.740113_g24332_i0	PRJNA745553	24527	250	1.740113	4.3502825	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	165	2.79e-36	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g24332	i0	87.162	181.736	148	15	58	4	106	250	16951	17097	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	45434	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
10127273	10127273	PRJNA745553_S_NODE_13248_length_338_cov_3.992453_g13053_i0	PRJNA745553	13248	338	3.992453	13.49449114	Prosthecobacter	48463	Bacteria	Bacteria	466	9.62e-127	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g13053	i0	94.684	218.207100591716	301	15	89	1	32	331	2841	2541	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	73754	466	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
10928016	10928016	PRJNA745553_S_NODE_12449_length_348_cov_2.301818_g12254_i0	PRJNA745553	12449	348	2.301818	8.01032664	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	577	4.3999999999999996e-160	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g12254	i0	96.552	109.16091954023	348	12	100	0	1	348	244	591	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	37988	577	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
10928169	10928169	PRJNA745553_S_NODE_20629_length_272_cov_3.894472_g20434_i0	PRJNA745553	20629	272	3.894472	10.59296384	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	246	1.0699999999999999e-60	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g20434	i0	84.585	110.566176470588	253	34	93	4	1	251	3450027	3450276	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	30074	246	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
10928260	10928260	PRJNA745553_S_NODE_26669_length_241_cov_3.886905_g26474_i0	PRJNA745553	26669	241	3.886905	9.36744105	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	241	4.310000000000001e-59	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g26474	i0	86.667	51.5228215767635	225	20	91	9	16	235	15372	15591	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	12417	241	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
12203913	12203913	PRJNA745553_S_NODE_7310_length_438_cov_5.542466_g7116_i0	PRJNA745553	7310	438	5.542466	24.27600108	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	436	1e-117	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g7116	i0	84.922	112.415525114155	451	46	100	20	1	438	1316781	1316340	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	49238	436	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13478080	13478080	PRJNA745553_S_NODE_26351_length_242_cov_8.644970_g26156_i0	PRJNA745553	26351	242	8.64497	20.9208274	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	171	5.77e-38	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g26156	i0	81.567	16.3388429752066	217	30	88	9	17	228	454799	454588	Luteolibacter sp. AS25 chromosome, complete genome	blastn	3954	171	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
13478140	13478140	PRJNA745553_S_NODE_2911_length_593_cov_2.880769_g2729_i0	PRJNA745553	2911	593	2.880769	17.08296017	Chthoniobacter flavus	191863	Bacteria	Bacteria	828	0	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g2729	i0	92.561	207.214165261383	578	42	97	1	11	588	733	157	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	122878	828	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
17302171	17302171	PRJNA745553_S_NODE_1474_length_706_cov_7.598736_g1334_i0	PRJNA745553	1474	706	7.598736	53.64707616	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	1114	0	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g1334	i0	96.847	263.712464589235	666	21	94	0	15	680	3412105	3412770	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	186181	1114	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
17302341	17302341	PRJNA745553_S_NODE_25234_length_247_cov_2.465517_g25039_i0	PRJNA745553	25234	247	2.465517	6.08982699	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	117	7.810000000000001e-22	NTclustered	gi\|2518556548\|emb\|OX638380.1\|	412056	g25039	i0	77.99	3.82591093117409	209	31	81	11	14	212	3919051	3918848	MAG: uncultured Verrucomicrobiae bacterium isolate efd5e50e-5b6a-4a0f-a0a2-e496bae301b3 genome assembly, chromosome: 1	blastn	945	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18575771	18575771	PRJNA745553_S_NODE_15275_length_315_cov_2.747934_g15080_i0	PRJNA745553	15275	315	2.747934	8.6559921	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	440	5.389999999999997e-119	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g15080	i0	93.023	187.073015873016	301	21	96	0	15	315	3411065	3411365	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	58928	440	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
18575781	18575781	PRJNA745553_S_NODE_15935_length_309_cov_1.673729_g15740_i0	PRJNA745553	15935	309	1.673729	5.17182261	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	254	7.37e-63	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g15740	i0	84.706	0.825242718446602	255	37	82	2	4	257	1051951	1051698	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	255	254	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
18576086	18576086	PRJNA745553_S_NODE_5555_length_486_cov_2.157385_g5361_i0	PRJNA745553	5555	486	2.157385	10.4848911	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	523	8.349999999999998e-144	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g5361	i0	86.583	240.600823045268	477	60	98	4	12	485	3116151	3115676	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	116932	523	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
19851044	19851044	PRJNA745553_S_NODE_11396_length_363_cov_1.182759_g11201_i0	PRJNA745553	11396	363	1.182759	4.29341517	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	621	2.09e-173	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g11201	i0	99.415	99.7575757575758	342	2	94	0	13	354	3556863	3557204	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	36212	621	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
19851109	19851109	PRJNA745553_S_NODE_15076_length_317_cov_4.061475_g14881_i0	PRJNA745553	15076	317	4.061475	12.87487575	uncultured Ruficoccus sp.	2175960	Bacteria	Bacteria	159	1.7e-34	NTclustered	gi\|2907625921\|emb\|OZ223481.1\|	2175960	g14881	i0	77	137.145110410095	300	56	93	12	4	298	740577	740286	MAG: uncultured Ruficoccus sp. isolate b2a3d85c-2e17-47e2-9e32-7ac6437316b9 genome assembly, chromosome: 10	blastn	43475	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Ruficoccus	uncultured Ruficoccus sp.
22401738	22401738	PRJNA745553_S_NODE_27498_length_236_cov_3.257669_g27303_i0	PRJNA745553	27498	236	3.257669	7.68809884	Actomonas aquatica	2866162	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g27303	i0	100	0.11864406779661	28	0	12	0	96	123	5984867	5984840	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica
22401746	22401746	PRJNA745553_S_NODE_28258_length_231_cov_2.518987_g28063_i0	PRJNA745553	28258	231	2.518987	5.81885997	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	274	4.05e-69	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g28063	i0	98.701	11.9480519480519	154	2	67	0	68	221	5626948	5627101	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	2760	274	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
23677193	23677193	PRJNA745553_S_NODE_20899_length_270_cov_8.157360_g20704_i0	PRJNA745553	20899	270	8.15736	22.024872	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	327	3.67e-85	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g20704	i0	92.241	60.8740740740741	232	16	85	2	23	252	3833600	3833369	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	16436	327	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24950647	24950647	PRJNA745553_S_NODE_17680_length_293_cov_5.636364_g17485_i0	PRJNA745553	17680	293	5.636364	16.51454652	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	265	3.21e-66	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g17485	i0	90.863	74.3276450511945	197	18	67	0	24	220	3411200	3411396	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	21778	265	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
24950766	24950766	PRJNA745553_S_NODE_25200_length_247_cov_3.517241_g25005_i0	PRJNA745553	25200	247	3.517241	8.68758527	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	324	4.2799999999999995e-84	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g25005	i0	92.576	101.14979757085	229	11	91	6	1	225	28443	28669	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	24984	324	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota 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);;