metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA489308" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA489308" and tax_kingdom = "Thermotogati"

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
11928803	11928803	PRJNA489308_P_NODE_22290_length_278_cov_1.126829_g22214_i0	PRJNA489308	22290	278	1.126829	3.13258462	Bacteria	2	Bacteria	Bacteria	130	6.830000000000001e-33	NR	MFN3265259.1	2478479	g22214	i0	68.5	13.8021582733813	92	29	99.3	0	276	1	28	119	MFN3265259.1 phosphoenolpyruvate carboxykinase (GTP) [Deinococcales bacterium]	diamond	3837	130	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales			Deinococcales bacterium
27613617	27613617	PRJNA489308_P_NODE_31904_length_249_cov_3.278409_g31828_i0	PRJNA489308	31904	249	3.278409	8.16323841	Synergistes sp.	2774297	Bacteria	Bacteria	64.7	7.23e-10	NR	MCF0248145.1	2774297	g31828	i0	48.4	2.19277108433735	64	29	72.3	1	180	1	2	65	MCF0248145.1 GTPase domain-containing protein [Synergistes sp.]	diamond	546	64.7	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Synergistes	Synergistes sp.
27708627	27708627	PRJNA489308_P_NODE_7144_length_404_cov_1.773414_g7068_i0	PRJNA489308	7144	404	1.773414	7.16459256	Fervidobacterium sp.	1871331	Bacteria	Bacteria	64.7	2.93e-9	NR	MFN3692273.1	1871331	g7068	i0	31.3	0.831683168316832	112	76	83.2	1	45	380	1	111	MFN3692273.1 transposase family protein [Fervidobacterium sp.]	diamond	336	64.7	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium sp.
29492300	29492300	PRJNA489308_P_NODE_14490_length_317_cov_1.254098_g14414_i0	PRJNA489308	14490	317	1.254098	3.97549066	Bacteria	2	Bacteria	Bacteria	71.6	1.34e-12	NR	WP_334099760.1	93929	g14414	i0	70.2	2.82965299684543	47	14	44.5	0	260	120	3	49	WP_334099760.1 viroplasmin family protein [Thermotoga petrophila]	diamond	897	71.6	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae	Thermotoga	Thermotoga petrophila
29871295	29871295	PRJNA489308_P_NODE_24831_length_268_cov_2.897436_g24755_i0	PRJNA489308	24831	268	2.897436	7.7651284800000004	Bacteria	2	Bacteria	Bacteria	57.4	6.44e-9	NR	WP_071608635.1	1008305	g24755	i0	81.3	2.25	32	6	35.8	0	96	1	2	33	WP_071608635.1 50S ribosomal protein L34 [Fervidobacterium thailandense]	diamond	603	57.4	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium thailandense
31087391	31087391	PRJNA489308_P_NODE_14415_length_317_cov_1.893443_g14339_i0	PRJNA489308	14415	317	1.893443	6.00221431	Thermotogaceae bacterium	2268206	Bacteria	Bacteria	68.6	7.49e-11	NR	MCD6102701.1	2268206	g14339	i0	41	4.90220820189274	78	36	73.8	1	314	81	20	87	MCD6102701.1 C69 family dipeptidase [Thermotogaceae bacterium]	diamond	1554	68.6	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Thermotogaceae		Thermotogaceae bacterium
31181861	31181861	PRJNA489308_P_NODE_19275_length_290_cov_1.645161_g19199_i0	PRJNA489308	19275	290	1.645161	4.7709669	Thermotogota bacterium	2053689	Bacteria	Bacteria	54.3	2.58e-6	NR	RKX40950.1	2053689	g19199	i0	47.1	2.05862068965517	70	33	72.4	3	210	1	29	94	RKX40950.1 MAG: translation initiation factor IF-3 [Thermotogota bacterium]	diamond	597	54.3	1	Bacteria	Thermotogati	Thermotogota					Thermotogota bacterium
32162987	32162987	PRJNA489308_P_NODE_998_length_897_cov_2.819175_g939_i0	PRJNA489308	998	897	2.819175	25.28799975	Synergistales bacterium	2268201	Bacteria	Bacteria	77.8	2.84e-13	NR	GHS94377.1	2268201	g939	i0	37.8	0.451505016722408	135	76	44.1	4	496	891	34	163	GHS94377.1 hypothetical protein AGMMS50276_06900 [Synergistales bacterium]	diamond	405	77.8	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales			Synergistales bacterium
32590241	32590241	PRJNA489308_P_NODE_15399_length_311_cov_1.294118_g15323_i0	PRJNA489308	15399	311	1.294118	4.02470698	Bacteria	2	Bacteria	Bacteria	44.7	0.0171	NR	WP_099829052.1	1421002	g15323	i0	34.9	4.16720257234727	86	50	83	3	50	307	315	394	WP_099829052.1 right-handed parallel beta-helix repeat-containing protein [Mesotoga sp. Brook.08.105.5.1]	diamond	1296	44.7	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Kosmotogales	Kosmotogaceae	Mesotoga	Mesotoga sp. Brook.08.105.5.1

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