metadata: contig_metadata: 12 rows where bioproject = "PRJEB28062", tax_kingdom = "Thermotogati" and tax

12 rows where bioproject = "PRJEB28062", 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
5127564	5127564	PRJEB28062_P_NODE_61965_length_443_cov_13.135135_g59605_i0	PRJEB28062	61965	443	13.135135	58.18864805	Thermanaerovibrio acidaminovorans	81462	Bacteria	Bacteria	701	0	NTclustered	gi\|269099254\|gb\|CP001818.1\|	525903	g59605	i0	98.492	0.898419864559819	398	5	90	1	26	422	1549186	1548789	Thermanaerovibrio acidaminovorans DSM 6589, complete genome	blastn	398	701	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Thermanaerovibrio	Thermanaerovibrio acidaminovorans
10228438	10228438	PRJEB28062_P_NODE_87709_length_352_cov_7.193548_g85347_i0	PRJEB28062	87709	352	7.193548	25.32128896	Thermanaerovibrio acidaminovorans	81462	Bacteria	Bacteria	588	2.05e-163	NTclustered	gi\|269099254\|gb\|CP001818.1\|	525903	g85347	i0	98.792	10.3892045454545	331	3	94	1	14	343	233124	233454	Thermanaerovibrio acidaminovorans DSM 6589, complete genome	blastn	3657	588	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Thermanaerovibrio	Thermanaerovibrio acidaminovorans
12777797	12777797	PRJEB28062_P_NODE_18051_length_889_cov_3.942402_g16072_i0	PRJEB28062	18051	889	3.942402	35.04795378	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	854	0	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g16072	i0	97.228	1.11361079865017	505	13	57	1	368	871	2002930	2003434	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	990	854	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
26906640	26906640	PRJEB28062_P_NODE_133762_length_230_cov_2.579618_g131398_i0	PRJEB28062	133762	230	2.579618	5.9331214	Synergistales bacterium	2268201	Bacteria	Bacteria	45.8	0.00133	NR	HOO89166.1	2268201	g131398	i0	72.7	1.16086956521739	22	6	28.7	0	5	70	116	137	HOO89166.1 GDP-mannose 4,6-dehydratase [Synergistales bacterium]	diamond	267	45.8	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales			Synergistales bacterium
29054451	29054451	PRJEB28062_P_NODE_112648_length_279_cov_3.140777_g110285_i0	PRJEB28062	112648	279	3.140777	8.76276783	Synergistaceae bacterium	2053624	Bacteria	Bacteria	72.4	1.22e-12	NR	MBQ6737035.1	2053624	g110285	i0	40	1.50537634408602	70	42	75.3	0	260	51	4	73	MBQ6737035.1 DUF2800 domain-containing protein [Synergistaceae bacterium]	diamond	420	72.4	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
29780498	29780498	PRJEB28062_P_NODE_54631_length_478_cov_8.479012_g52278_i0	PRJEB28062	54631	478	8.479012	40.52967736	uncultured Fretibacterium sp.	1678694	Bacteria	Bacteria	192	5.7499999999999985e-56	NR	WP_299300527.1	1678694	g52278	i0	90	0.690376569037657	110	11	69	0	36	365	347	456	WP_299300527.1 UDP-N-acetylmuramoyl-L-alanine--D-glutamate ligase [uncultured Fretibacterium sp.]	diamond	330	192	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	uncultured Fretibacterium sp.
29843676	29843676	PRJEB28062_P_NODE_45591_length_532_cov_21.137255_g43251_i0	PRJEB28062	45591	532	21.137255	112.4501966	Fretibacterium sp.	2699746	Bacteria	Bacteria	167	8.599999999999999e-48	NR	NLL37143.1	2699746	g43251	i0	80.4	1.7593984962406	102	20	57.5	0	327	22	3	104	NLL37143.1 ABC transporter permease [Fretibacterium sp.]	diamond	936	167	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium sp.
30633345	30633345	PRJEB28062_P_NODE_59993_length_452_cov_8.065963_g57633_i0	PRJEB28062	59993	452	8.065963	36.45815276	Synergistaceae bacterium	2053624	Bacteria	Bacteria	63.2	2.26e-8	NR	MEA4872224.1	2053624	g57633	i0	33.6	0.969026548672566	146	88	92.9	7	19	438	42	184	MEA4872224.1 zinc ribbon domain-containing protein [Synergistaceae bacterium]	diamond	438	63.2	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae bacterium
30759973	30759973	PRJEB28062_P_NODE_18454_length_878_cov_8.404969_g16467_i0	PRJEB28062	18454	878	8.404969	73.795627820000007	uncultured Fretibacterium sp.	1678694	Bacteria	Bacteria	420	1.5099999999999999e-142	NR	WP_299301840.1	1678694	g16467	i0	92.9	0.765375854214123	224	16	76.5	0	4	675	272	495	WP_299301840.1 UDP-N-acetylmuramoyl-L-alanyl-D-glutamate--2,6-diaminopimelate ligase [uncultured Fretibacterium sp.]	diamond	672	420	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	uncultured Fretibacterium sp.
31075980	31075980	PRJEB28062_P_NODE_33435_length_635_cov_9.846975_g31124_i0	PRJEB28062	33435	635	9.846975	62.52829125	uncultured Fretibacterium sp.	1678694	Bacteria	Bacteria	347	1.0799999999999999e-116	NR	WP_299076655.1	1678694	g31124	i0	94	0.949606299212598	201	12	95	0	22	624	125	325	WP_299076655.1 ABC transporter permease [uncultured Fretibacterium sp.]	diamond	603	347	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	uncultured Fretibacterium sp.
31392225	31392225	PRJEB28062_P_NODE_87476_length_353_cov_2.689286_g85114_i0	PRJEB28062	87476	353	2.689286	9.49317958	uncultured Fretibacterium sp.	1678694	Bacteria	Bacteria	159	2.7e-44	NR	WP_347712700.1	1678694	g85114	i0	88.4	0.807365439093484	95	11	80.7	0	2	286	2	96	WP_347712700.1 hypothetical protein [uncultured Fretibacterium sp.]	diamond	285	159	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	uncultured Fretibacterium sp.
32467878	32467878	PRJEB28062_P_NODE_111319_length_283_cov_1.366667_g108956_i0	PRJEB28062	111319	283	1.366667	3.86766761	Synergistota bacterium	2268202	Bacteria	Bacteria	90.5	3.93e-20	NR	MCS7233147.1	2268202	g108956	i0	63.4	2.93639575971731	93	34	98.6	0	279	1	16	108	MCS7233147.1 4Fe-4S binding protein [Synergistota bacterium]	diamond	831	90.5	1	Bacteria	Thermotogati	Synergistota					Synergistota 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);;