metadata: contig_metadata: 8 rows where bioproject = "PRJNA493632", tax_kingdom = "Thermotogati" and tax

8 rows where bioproject = "PRJNA493632", tax_kingdom = "Thermotogati" 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
9393671	9393671	PRJNA493632_P_NODE_537768_length_249_cov_0.875000_g534329_i0	PRJNA493632	537768	249	0.875	2.17875	Jonquetella	428711	Bacteria	Bacteria	110	3.81e-26	NR	WP_008523232.1	428711	g534329	i0	100	0.650602409638554	54	0	65.1	0	164	3	1	54	WP_008523232.1 MULTISPECIES: glutamine--fructose-6-phosphate transaminase (isomerizing) [Jonquetella]	diamond	162	110	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Jonquetella
22144696	22144696	PRJNA493632_P_NODE_686738_length_232_cov_2.830189_g683297_i0	PRJNA493632	686738	232	2.830189	6.56603848	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	307	4.0100000000000005e-79	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g683297	i0	90.638	305.314655172414	235	16	100	6	1	232	68646	68877	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	70833	307	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
28118882	28118882	PRJNA493632_P_NODE_728285_length_202_cov_8.155039_g724842_i0	PRJNA493632	728285	202	8.155039	16.47317878	Jonquetella	428711	Bacteria	Bacteria	142	1.8299999999999999e-38	NR	WP_008521425.1	428711	g724842	i0	100	0.98019801980198	66	0	98	0	200	3	399	464	WP_008521425.1 MULTISPECIES: S10 family serine carboxypeptidase-like protein [Jonquetella]	diamond	198	142	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Jonquetella
28813226	28813226	PRJNA493632_P_NODE_538348_length_249_cov_0.875000_g534909_i0	PRJNA493632	538348	249	0.875	2.17875	Synergistaceae bacterium	2053624	Bacteria	Bacteria	128	1.32e-36	NR	MDD5420831.1	2053624	g534909	i0	96.9	0.783132530120482	65	2	78.3	0	249	55	20	84	MDD5420831.1 TlyA family RNA methyltransferase [Synergistaceae bacterium]	diamond	195	128	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
29082032	29082032	PRJNA493632_P_NODE_623888_length_243_cov_0.905882_g620447_i0	PRJNA493632	623888	243	0.905882	2.20129326	Synergistales	649776	Bacteria	Bacteria	126	3.01e-34	NR	WP_367338614.1	1872489	g620447	i0	76.3	2.96296296296296	80	19	98.8	0	241	2	103	182	WP_367338614.1 polysaccharide deacetylase family protein [Aminivibrio sp.]	diamond	720	126	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Aminivibrio	Aminivibrio sp.
31799048	31799048	PRJNA493632_P_NODE_467997_length_258_cov_2.178378_g464558_i0	PRJNA493632	467997	258	2.178378	5.62021524	root	1	Root_unresolved	Root_unresolved	65.1	5.78e-10	NR	KUK57941.1	1635273	g464558	i0	58.7	5.3953488372093	46	19	53.5	0	256	119	415	460	KUK57941.1 MAG: Bifunctional protein GlmU [Synergistales bacterium 53_16]	diamond	1392	65.5	0.993893129770992	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales			Synergistales bacterium 53_16
31988993	31988993	PRJNA493632_P_NODE_626418_length_243_cov_0.905882_g622977_i0	PRJNA493632	626418	243	0.905882	2.20129326	Caenicola	3416956	Bacteria	Bacteria	140	2.3999999999999998e-39	NR	MCW1713653.1	2006111	g622977	i0	100	1.75308641975309	71	0	87.7	0	243	31	200	270	MCW1713653.1 GAF domain-containing protein [Synergistaceae bacterium DZ-S4]	diamond	426	140	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Caenicola	Caenicola nitritireducens
32036518	32036518	PRJNA493632_P_NODE_602318_length_245_cov_0.895349_g598877_i0	PRJNA493632	602318	245	0.895349	2.19360505	Synergistales bacterium	2268201	Bacteria	Bacteria	44.3	0.00999	NR	MBC7077358.1	2268201	g598877	i0	52.9	0.416326530612245	34	15	41.6	1	178	77	51	83	MBC7077358.1 UbiA family prenyltransferase [Synergistales bacterium]	diamond	102	44.3	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales			Synergistales 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);;