metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJEB73599" and tax

20 rows where analysis = "blastn", bioproject = "PRJEB73599" 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
1409757	1409757	PRJEB73599_P_NODE_362_length_1212_cov_17.841082_g172_i2	PRJEB73599	362	1212	17.841082	216.23391384	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1895	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g172	i2	94.967	112.650165016502	1212	56	99	5	4	1212	5153737	5152528	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	136532	1895	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2685254	2685254	PRJEB73599_P_NODE_4203_length_333_cov_4.615132_g3916_i0	PRJEB73599	4203	333	4.615132	15.36838956	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	300	1.02e-76	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g3916	i0	88.664	126.621621621622	247	27	94	1	87	333	1403603	1403848	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	42165	300	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
3961318	3961318	PRJEB73599_P_NODE_9464_length_162_cov_6.977444_g9177_i0	PRJEB73599	9464	162	6.977444	11.30345928	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	217	4.5199999999999996e-52	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g9177	i0	90.741	95.4135802469136	162	15	100	0	1	162	5152392	5152553	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	15457	217	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
6098683	6098683	PRJEB73599_P_NODE_1225_length_678_cov_6.052388_g1033_i0	PRJEB73599	1225	678	6.052388	41.03519064	Verrucomicrobiota	74201	Bacteria	Bacteria	553	1.5199999999999995e-152	NTclustered	gi\|297180506\|gb\|GU474845.1\|	710995	g1033	i0	83.498	96.1401179941003	606	86	89	12	78	678	1169	1765	Uncultured Verrucomicrobiales bacterium HF0010_05E02 genomic sequence	blastn	65183	555	0.996396396396396	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			uncultured Verrucomicrobiales bacterium HF0010_05E02
7787545	7787545	PRJEB73599_P_NODE_4407_length_322_cov_8.470990_g4120_i0	PRJEB73599	4407	322	8.47099	27.2765878	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	422	2e-113	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g4120	i0	90.596	35.7080745341615	319	29	99	1	5	322	1316535	1316217	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	11498	422	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9062436	9062436	PRJEB73599_P_NODE_2888_length_427_cov_9.608040_g2609_i0	PRJEB73599	2888	427	9.60804	41.0263308	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	595	1.5199999999999994e-165	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g2609	i0	91.803	115.351288056206	427	35	100	0	1	427	1519	1093	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	49255	595	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
12888694	12888694	PRJEB73599_P_NODE_10031_length_152_cov_3.268293_g9744_i0	PRJEB73599	10031	152	3.268293	4.96780536	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	115	1.5600000000000002e-21	NTclustered	gi\|1085974270\|emb\|LT629781.1\|	1882831	g9744	i0	82.443	19.1052631578947	131	23	86	0	1	131	3537760	3537890	Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I	blastn	2904	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
12888754	12888754	PRJEB73599_P_NODE_6351_length_239_cov_2.380952_g6064_i0	PRJEB73599	6351	239	2.380952	5.69047528	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	344	3.16e-90	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g6064	i0	91.632	19.4058577405858	239	17	100	2	1	239	27788	27553	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	4638	344	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
12888767	12888767	PRJEB73599_P_NODE_8311_length_184_cov_8.348387_g8024_i0	PRJEB73599	8311	184	8.348387	15.36103208	Pedosphaera parvula	1032527	Bacteria	Bacteria	255	1.11e-63	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g8024	i0	92.308	25.3369565217391	182	11	98	2	4	183	1117	937	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	4662	255	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
12888780	12888780	PRJEB73599_P_NODE_9931_length_154_cov_3.056000_g9644_i0	PRJEB73599	9931	154	3.056	4.70624	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	183	4.3e-42	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g9644	i0	88.387	123.402597402597	155	15	100	3	1	154	1728141	1727989	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	19004	183	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14163603	14163603	PRJEB73599_P_NODE_672_length_918_cov_695.152981_g539_i0	PRJEB73599	672	918	695.152981	6381.50436558	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	959	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g539	i0	93.009	68.9945533769063	658	45	92	1	1	657	1316245	1315588	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	63337	959	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15023405	15023405	PRJEB73599_P_NODE_232_length_1438_cov_15.216466_g172_i0	PRJEB73599	232	1438	15.216466	218.81278108	Verrucomicrobiota	74201	Bacteria	Bacteria	1783	0	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g172	i0	89.382	108.376216968011	1441	120	99	27	12	1435	915	2339	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	155845	1783	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
15437630	15437630	PRJEB73599_P_NODE_2113_length_509_cov_11.039583_g1857_i0	PRJEB73599	2113	509	11.039583	56.19147747	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	621	3.0299999999999997e-173	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g1857	i0	88.824	141.60510805501	510	52	100	3	1	509	1315438	1314933	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	72077	621	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15437637	15437637	PRJEB73599_P_NODE_2673_length_447_cov_14.954545_g2397_i0	PRJEB73599	2673	447	14.954545	66.84681615	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	348	4.93e-91	NTclustered	gi\|164510704\|emb\|AJ966883.1\|	48466	g2397	i0	98	173.612975391499	200	4	45	0	1	200	4547	4746	Prosthecobacter vanneervenii 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 12252	blastn	77605	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
16298147	16298147	PRJEB73599_P_NODE_3313_length_393_cov_24.766484_g3027_i0	PRJEB73599	3313	393	24.766484	97.33228212	Verrucomicrobiota	74201	Bacteria	Bacteria	599	1.0699999999999997e-166	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g3027	i0	94.148	102.641221374046	393	23	100	0	1	393	5154809	5154417	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	40338	599	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
16711838	16711838	PRJEB73599_P_NODE_3134_length_406_cov_9.212202_g2848_i0	PRJEB73599	3134	406	9.212202	37.40154012	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	457	7.0699999999999984e-124	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g2848	i0	87.198	60.4187192118227	414	38	100	13	1	406	1316623	1316217	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	24530	457	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
16711881	16711881	PRJEB73599_P_NODE_7814_length_195_cov_3.433735_g7527_i0	PRJEB73599	7814	195	3.433735	6.69578325	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	333	5.369999999999999e-87	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g7527	i0	97.436	28.3794871794872	195	5	100	0	1	195	196	390	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	5534	333	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
17986751	17986751	PRJEB73599_P_NODE_4295_length_329_cov_2.116667_g4008_i0	PRJEB73599	4295	329	2.116667	6.96383443	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	401	2.6699999999999992e-107	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g4008	i0	88.991	132.747720364742	327	33	99	3	1	326	2317	1993	Luteolibacter sp. SL250 chromosome	blastn	43674	401	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
24360984	24360984	PRJEB73599_P_NODE_3300_length_394_cov_7.441096_g3014_i0	PRJEB73599	3300	394	7.441096	29.31791824	Fontisphaera persica	2974023	Bacteria	Bacteria	484	3.14e-132	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g3014	i0	88.889	102.809644670051	396	40	100	4	1	394	3863542	3863149	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	40507	484	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
24360988	24360988	PRJEB73599_P_NODE_360_length_1213_cov_17.349662_g172_i1	PRJEB73599	360	1213	17.349662	210.45140006	Opitutus sp. VeGlc2	134634	Bacteria	Bacteria	1864	0	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g172	i1	94.472	111.737840065952	1212	63	99	4	4	1213	2339	1130	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	135538	1864	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2

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