metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA493244" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA493244" 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
455824	455824	PRJNA493244_P_NODE_1486761_length_246_cov_1.383784_g1463636_i0	PRJNA493244	1486761	246	1.383784	3.40410864	Congregicoccus parvus	3081749	Bacteria	Bacteria	97.1	1.01e-15	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g1463636	i0	93.75	12.2560975609756	64	4	26	0	1	64	5297558	5297495	Opitutales bacterium ASA1 DNA, complete genome	blastn	3015	97.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
1730842	1730842	PRJNA493244_P_NODE_1616262_length_217_cov_1.519231_g1593137_i0	PRJNA493244	1616262	217	1.519231	3.29673127	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	185	1.81e-42	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g1593137	i0	82.273	1.01382488479263	220	33	100	6	1	217	369597	369381	Lacunisphaera limnophila strain IG16b, complete genome	blastn	220	185	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
3005703	3005703	PRJNA493244_P_NODE_1129563_length_354_cov_2.170648_g1106441_i0	PRJNA493244	1129563	354	2.170648	7.68409392	Horticoccus luteus	2862869	Bacteria	Bacteria	276	1.83e-69	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g1106441	i0	82.154	7.32203389830508	325	54	91	4	32	354	3132980	3132658	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	2592	276	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
4283316	4283316	PRJNA493244_P_NODE_1683164_length_206_cov_0.882759_g1660039_i0	PRJNA493244	1683164	206	0.882759	1.81848354	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	292	9.75e-75	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g1660039	i0	92.233	80.0631067961165	206	16	100	0	1	206	53037	53242	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	16493	292	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
5559539	5559539	PRJNA493244_P_NODE_1560805_length_229_cov_1.523810_g1537680_i0	PRJNA493244	1560805	229	1.52381	3.4895249	Horticoccus luteus	2862869	Bacteria	Bacteria	134	7.090000000000001e-27	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g1537680	i0	92.473	4.51091703056769	93	7	41	0	77	169	966164	966256	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	1033	134	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
6834161	6834161	PRJNA493244_P_NODE_1743426_length_189_cov_4.000000_g1720301_i0	PRJNA493244	1743426	189	4	7.56	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	261	2.4800000000000002e-65	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g1720301	i0	91.579	87.3015873015873	190	14	100	2	1	189	1315141	1314953	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	16500	261	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8108302	8108302	PRJNA493244_P_NODE_1218687_length_322_cov_4.674330_g1195563_i0	PRJNA493244	1218687	322	4.67433	15.0513426	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	254	7.72e-63	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g1195563	i0	83.217	95.7204968944099	286	38	88	7	15	297	3048592	3048870	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	30822	254	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
8109077	8109077	PRJNA493244_P_NODE_1553727_length_230_cov_7.988166_g1530602_i0	PRJNA493244	1553727	230	7.988166	18.3727818	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	231	2.4599999999999996e-56	NTclustered	gi\|2874253793\|emb\|OY969777.1\|	412056	g1530602	i0	86.667	241.213043478261	210	26	91	2	22	230	2366166	2365958	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1	blastn	55479	231	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8109089	8109089	PRJNA493244_P_NODE_1556087_length_230_cov_1.514793_g1532962_i0	PRJNA493244	1556087	230	1.514793	3.4840239	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	185	1.94e-42	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g1532962	i0	83.575	31.4913043478261	207	25	90	4	22	228	4011786	4011589	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	7243	185	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8752594	8752594	PRJNA493244_P_NODE_1317407_length_291_cov_11.278261_g1294283_i0	PRJNA493244	1317407	291	11.278261	32.81973951	Opitutus	178440	Bacteria	Bacteria	368	2.36e-97	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g1294283	i0	91.698	123.525773195876	265	22	91	0	24	288	903	1167	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	35946	368	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
9383290	9383290	PRJNA493244_P_NODE_1317528_length_291_cov_6.178261_g1294404_i0	PRJNA493244	1317528	291	6.178261	17.97873951	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	294	4.06e-75	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g1294404	i0	89.212	173.807560137457	241	19	81	6	1	236	26925	27163	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	50578	294	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
11936423	11936423	PRJNA493244_P_NODE_925250_length_441_cov_3.313158_g902260_i0	PRJNA493244	925250	441	3.313158	14.61102678	Opitutus terrae	107709	Bacteria	Bacteria	52.8	0.043	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g902260	i0	96.774	0.0702947845804989	31	1	7	0	101	131	440682	440712	Opitutus terrae PB90-1, complete genome	blastn	31	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
13208726	13208726	PRJNA493244_P_NODE_1136591_length_351_cov_4.310345_g1113469_i0	PRJNA493244	1136591	351	4.310345	15.12931095	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	337	8.18e-88	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g1113469	i0	85.627	19.3390313390313	327	40	92	7	1	324	505	183	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	6788	337	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
13209757	13209757	PRJNA493244_P_NODE_1577231_length_225_cov_2.341463_g1554106_i0	PRJNA493244	1577231	225	2.341463	5.26829175	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	60.2	1.2e-4	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g1554106	i0	94.872	0.373333333333333	39	1	19	1	16	54	3823996	3824033	Luteolibacter sp. SL250 chromosome	blastn	84	60.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
14486654	14486654	PRJNA493244_P_NODE_998392_length_407_cov_10.549133_g975308_i0	PRJNA493244	998392	407	10.549133	42.93497131	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	285	3.5399999999999996e-72	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g975308	i0	81.117	46.6977886977887	376	53	88	11	21	380	3832520	3832147	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	19006	285	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20857931	20857931	PRJNA493244_P_NODE_1673277_length_207_cov_0.876712_g1650152_i0	PRJNA493244	1673277	207	0.876712	1.81479384	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	204	4.7299999999999996e-48	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g1650152	i0	86.17	26.5845410628019	188	26	91	0	1	188	908133	907946	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	5503	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
20859272	20859272	PRJNA493244_P_NODE_816557_length_497_cov_10.149083_g793822_i0	PRJNA493244	816557	497	10.149083	50.44094251	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	616	1.3699999999999996e-171	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g793822	i0	90.426	153.243460764588	470	41	94	4	30	497	1904251	1903784	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	76162	616	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
22132328	22132328	PRJNA493244_P_NODE_1514238_length_239_cov_11.595506_g1491113_i0	PRJNA493244	1514238	239	11.595506	27.71325934	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	394	3.099999999999999e-105	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g1491113	i0	99.539	121.669456066946	217	0	90	1	24	239	2833140	2833356	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	29079	394	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
24682265	24682265	PRJNA493244_P_NODE_1683420_length_206_cov_0.882759_g1660295_i0	PRJNA493244	1683420	206	0.882759	1.81848354	Horticoccus luteus	2862869	Bacteria	Bacteria	152	1.73e-32	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g1660295	i0	80.882	1.97572815533981	204	29	97	10	4	202	2799698	2799896	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	407	152	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus

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);;