metadata: contig_metadata: 9 rows where bioproject = "PRJNA807347" and tax

9 rows where bioproject = "PRJNA807347" 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
2082052	2082052	PRJNA807347_P_NODE_17202_length_242_cov_0.911243_g17099_i0	PRJNA807347	17202	242	0.911243	2.20520806	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	425	1.11e-114	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g17099	i0	98.347	5.03305785123967	242	4	100	0	1	242	1664464	1664223	Thermus sp. NEB1569 chromosome, complete genome	blastn	1218	425	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
3357190	3357190	PRJNA807347_P_NODE_11123_length_257_cov_1.684783_g11020_i0	PRJNA807347	11123	257	1.684783	4.32989231	Truepera radiovictrix	332249	Bacteria	Bacteria	129	1.4799999999999998e-32	NR	WP_013177283.1	332249	g11020	i0	78.8	0.992217898832685	85	18	99.2	0	257	3	468	552	WP_013177283.1 GAF domain-containing sensor histidine kinase [Truepera radiovictrix]	diamond	255	129	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
11010120	11010120	PRJNA807347_P_NODE_12869_length_250_cov_0.881356_g12766_i0	PRJNA807347	12869	250	0.881356	2.20339	Deinococcus	1298	Bacteria	Bacteria	145	2.53e-40	NR	WP_155300277.1	1298	g12766	i0	92.8	0.996	83	6	99.6	0	2	250	123	205	WP_155300277.1 MULTISPECIES: carbohydrate ABC transporter permease [Deinococcus]	diamond	249	145	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus
16108698	16108698	PRJNA807347_P_NODE_11973_length_252_cov_0.871508_g11870_i0	PRJNA807347	11973	252	0.871508	2.19620016	Fervidobacterium pennivorans	93466	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g11870	i0	100	3	252	0	100	0	1	252	175470	175219	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	756	466	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
18657652	18657652	PRJNA807347_P_NODE_12575_length_251_cov_0.870787_g12472_i0	PRJNA807347	12575	251	0.870787	2.18567537	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	448	2.48e-121	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g12472	i0	98.805	8.8605577689243	251	3	100	0	1	251	1818017	1818267	Thermus sp. NEB1569 chromosome, complete genome	blastn	2224	448	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
27938688	27938688	PRJNA807347_P_NODE_14265_length_247_cov_0.896552_g14162_i0	PRJNA807347	14265	247	0.896552	2.21448344	Deinococcus arenae	1452751	Bacteria	Bacteria	156	2.46e-42	NR	WP_189062661.1	1452751	g14162	i0	97.6	1.9919028340081	82	2	99.6	0	246	1	7	88	WP_189062661.1 HD domain-containing phosphohydrolase [Deinococcus arenae]	diamond	492	156	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus arenae
28570017	28570017	PRJNA807347_P_NODE_13627_length_248_cov_3.177143_g13524_i0	PRJNA807347	13627	248	3.177143	7.87931464	Synergistales bacterium	2268201	Bacteria	Bacteria	53.1	3.52e-7	NR	GHV45307.1	2268201	g13524	i0	63	0.326612903225806	27	10	32.7	0	156	76	33	59	GHV45307.1 hypothetical protein FACS1894204_04090 [Synergistales bacterium]	diamond	81	53.1	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales			Synergistales bacterium
31318069	31318069	PRJNA807347_P_NODE_13295_length_249_cov_0.886364_g13192_i0	PRJNA807347	13295	249	0.886364	2.20704636	Jonquetella	428711	Bacteria	Bacteria	158	1.24e-46	NR	WP_008520418.1	428711	g13192	i0	100	0.987951807228916	82	0	98.8	0	2	247	91	172	WP_008520418.1 MULTISPECIES: ribonuclease III family protein [Jonquetella]	diamond	246	158	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Jonquetella
32898159	32898159	PRJNA807347_P_NODE_17000_length_242_cov_0.923077_g16897_i0	PRJNA807347	17000	242	0.923077	2.23384634	Trueperaceae bacterium	2026798	Bacteria	Bacteria	97.8	9.4e-22	NR	HEX7041243.1	2026798	g16897	i0	59.5	0.979338842975207	79	30	97.9	1	1	237	52	128	HEX7041243.1 AAA family ATPase [Trueperaceae bacterium]	diamond	237	97.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae 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);;