metadata: contig_metadata: 20 rows where bioproject = "PRJNA630162" and tax

20 rows where bioproject = "PRJNA630162" and tax_phylum = "Synergistota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
602278	602278	PRJNA630162_P_NODE_42701_length_271_cov_3.842342_g41178_i0	PRJNA630162	42701	271	3.842342	10.41274682	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	486	5.7499999999999985e-133	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g41178	i0	99.624	93.1033210332103	266	1	98	0	6	271	1172542	1172807	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	25231	486	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
1877602	1877602	PRJNA630162_P_NODE_115962_length_176_cov_2.787402_g114439_i0	PRJNA630162	115962	176	2.787402	4.90582752	Pyramidobacter sp. YE332	3068894	Bacteria	Bacteria	287	3.74e-73	NTclustered	gi\|2601021520\|gb\|CP133038.1\|	3068894	g114439	i0	97.059	1.92613636363636	170	5	97	0	3	172	2677843	2678012	Pyramidobacter sp. YE332 chromosome, complete genome	blastn	339	287	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Pyramidobacter	Pyramidobacter sp. YE332
5706320	5706320	PRJNA630162_P_NODE_80705_length_200_cov_3.192053_g79182_i0	PRJNA630162	80705	200	3.192053	6.384106	uncultured Dethiosulfovibrio sp.	185448	Bacteria	Bacteria	171	4.599999999999999e-38	NTclustered	gi\|2621705290\|emb\|OY763420.1\|	185448	g79182	i0	86.061	467.24	165	15	81	6	4	165	764033	763874	MAG: uncultured Dethiosulfovibrio sp. isolate 94f88398-021e-4021-9552-bf231e535e7d genome assembly, chromosome: 1	blastn	93448	171	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Dethiosulfovibrio	uncultured Dethiosulfovibrio sp.
6255359	6255359	PRJNA630162_P_NODE_93245_length_190_cov_1.134752_g91722_i0	PRJNA630162	93245	190	1.134752	2.1560288	Pyramidobacter	638847	Bacteria	Bacteria	224	3.2699999999999995e-54	NTclustered	gi\|167996909\|gb\|EU379932.1\|	352165	g91722	i0	88.649	7.78947368421053	185	19	97	2	6	189	2471	2654	Synergistes sp. W5455 16S ribosomal RNA gene, 16S-23S ribosomal RNA intergenic spacer, 23S ribosomal RNA gene, 23S-5S ribosomal RNA intergenic spacer, and 5S ribosomal RNA gene, complete sequence	blastn	1480	224	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Pyramidobacter	Pyramidobacter piscolens
8254692	8254692	PRJNA630162_P_NODE_126547_length_171_cov_1.614754_g125024_i0	PRJNA630162	126547	171	1.614754	2.76122934	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	252	1.32e-62	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g125024	i0	94.012	4.75438596491228	167	9	97	1	1	166	69426	69592	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	813	252	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
10805524	10805524	PRJNA630162_P_NODE_103829_length_183_cov_2.044776_g102306_i0	PRJNA630162	103829	183	2.044776	3.74194008	Jonquetella anthropi	428712	Bacteria	Bacteria	167	5.33e-37	NTclustered	gi\|194410714\|gb\|EU840722.1\|	428712	g102306	i0	93.694	78.2131147540984	111	7	61	0	7	117	1557	1667	Jonquetella anthropi strain E3_33 23S ribosomal RNA gene, partial sequence	blastn	14313	167	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Jonquetella	Jonquetella anthropi
10806398	10806398	PRJNA630162_P_NODE_32969_length_313_cov_2.969697_g31447_i0	PRJNA630162	32969	313	2.969697	9.29515161	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	455	1.9100000000000003e-123	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g31447	i0	93.791	93.2555910543131	306	13	97	6	9	312	68903	68602	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	29189	455	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
12080755	12080755	PRJNA630162_P_NODE_102610_length_184_cov_1.496296_g101087_i0	PRJNA630162	102610	184	1.496296	2.75318464	Synergistaceae bacterium	2053624	Bacteria	Bacteria	217	5.26e-52	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g101087	i0	89.595	405.820652173913	173	15	97	3	1	172	325788	325958	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	74671	217	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
12081893	12081893	PRJNA630162_P_NODE_60750_length_226_cov_4.412429_g59227_i0	PRJNA630162	60750	226	4.412429	9.97208954	Synergistales bacterium	2268201	Bacteria	Bacteria	231	2.4099999999999996e-56	NTclustered	gi\|2621703689\|emb\|OY762654.1\|	2268201	g59227	i0	85.903	329.16814159292	227	21	98	10	1	222	236766	236986	MAG: Synergistales bacterium isolate e2a2af2a-30b9-47e3-8e03-f1be080e1666 genome assembly, chromosome: 1	blastn	74392	231	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales			Synergistales bacterium
12082043	12082043	PRJNA630162_P_NODE_74890_length_208_cov_1.264151_g73367_i0	PRJNA630162	74890	208	1.264151	2.62943408	Synergistaceae bacterium	2053624	Bacteria	Bacteria	99	2.31e-16	NTclustered	gi\|2626233883\|emb\|OY821326.1\|	2053624	g73367	i0	83.962	60.4615384615385	106	13	50	4	99	203	324944	325046	MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1	blastn	12576	99	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
15904884	15904884	PRJNA630162_P_NODE_17453_length_447_cov_3.605528_g15949_i0	PRJNA630162	17453	447	3.605528	16.11671016	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	647	0	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g15949	i0	93.379	120.440715883669	438	27	98	2	2	438	69429	69865	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	53837	647	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
15904901	15904901	PRJNA630162_P_NODE_18373_length_434_cov_3.337662_g16863_i0	PRJNA630162	18373	434	3.337662	14.48545308	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	427	5.9599999999999985e-115	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g16863	i0	87.206	30.3433179723502	383	39	87	9	7	384	68741	68364	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	13169	427	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
15905401	15905401	PRJNA630162_P_NODE_65333_length_219_cov_1.111765_g63810_i0	PRJNA630162	65333	219	1.111765	2.43476535	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	311	2.9000000000000004e-80	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g63810	i0	93.333	218.744292237443	210	14	96	0	6	215	67498	67289	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	47905	311	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
15905665	15905665	PRJNA630162_P_NODE_93993_length_189_cov_1.964286_g92470_i0	PRJNA630162	93993	189	1.964286	3.71250054	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	141	3.3600000000000003e-29	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g92470	i0	80.749	22.015873015873	187	31	98	5	1	185	68549	68732	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	4161	141	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
18453530	18453530	PRJNA630162_P_NODE_12415_length_540_cov_16.541752_g10948_i0	PRJNA630162	12415	540	16.541752	89.3254608	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	802	0	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g10948	i0	93.68	321.807407407407	538	30	99	4	1	536	68965	69500	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	173776	802	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
18453701	18453701	PRJNA630162_P_NODE_142555_length_166_cov_1.572650_g141032_i0	PRJNA630162	142555	166	1.57265	2.610599	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	165	1.7100000000000002e-36	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g141032	i0	85.185	96.3192771084337	162	22	96	2	6	165	67393	67232	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	15989	165	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
18453916	18453916	PRJNA630162_P_NODE_164655_length_159_cov_3.327273_g163132_i0	PRJNA630162	164655	159	3.327273	5.29036407	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	150	4.54e-32	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g163132	i0	89.744	103.339622641509	117	12	74	0	43	159	69880	69996	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	16431	150	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
23554170	23554170	PRJNA630162_P_NODE_130739_length_169_cov_1.583333_g129216_i0	PRJNA630162	130739	169	1.583333	2.67583277	Jonquetella anthropi	428712	Bacteria	Bacteria	119	1.37e-22	NTclustered	gi\|194410714\|gb\|EU840722.1\|	428712	g129216	i0	90.11	121.467455621302	91	9	54	0	71	161	258	168	Jonquetella anthropi strain E3_33 23S ribosomal RNA gene, partial sequence	blastn	20528	119	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Jonquetella	Jonquetella anthropi
27093381	27093381	PRJNA630162_P_NODE_160342_length_162_cov_0.920354_g158819_i0	PRJNA630162	160342	162	0.920354	1.49097348	FCB group	1783270	Bacteria	Bacteria	63.2	2.07e-11	NR	MFA7219315.1	2053624	g158819	i0	56.6	1.94444444444444	53	21	94.4	1	155	3	12	64	MFA7219315.1 hypothetical protein [Synergistaceae bacterium]	diamond	315	63.5	0.995275590551181	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
32546983	32546983	PRJNA630162_P_NODE_107639_length_181_cov_1.500000_g106116_i0	PRJNA630162	107639	181	1.5	2.715	Synergistaceae bacterium	2053624	Bacteria	Bacteria	51.6	1.19e-5	NR	MBR1602881.1	2053624	g106116	i0	45.8	3.23204419889503	59	32	97.8	0	179	3	2545	2603	MBR1602881.1 hypothetical protein [Synergistaceae bacterium]	diamond	585	51.6	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae 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);;