metadata: contig_metadata: 8 rows where bioproject = "PRJNA627467", tax_kingdom = "Pseudomonadati" and tax

8 rows where bioproject = "PRJNA627467", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermomicrobiota"

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
13904765	13904765	PRJNA627467_P_NODE_19091_length_161_cov_2.812500_g19022_i0	PRJNA627467	19091	161	2.8125	4.528125	Thermomicrobium	499	Bacteria	Bacteria	73.1	1.03e-8	NTclustered	gi\|507148389\|ref\|NR_103192.1\|	500	g19022	i0	76.259	6.16770186335404	139	31	86	2	11	148	385	522	Thermomicrobium roseum strain DSM 5159 23S ribosomal RNA gene, complete sequence	blastn	993	73.1	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	Thermomicrobium roseum
19725813	19725813	PRJNA627467_P_NODE_316_length_557_cov_4.460630_g254_i0	PRJNA627467	316	557	4.46063	24.8457091	Thermomicrobium roseum	500	Bacteria	Bacteria	130	2.46e-25	NTclustered	gi\|221157271\|gb\|CP001276.1\|	309801	g254	i0	91.579	36.705565529623	95	7	17	1	167	260	535792	535698	Thermomicrobium roseum DSM 5159 plasmid, complete sequence	blastn	20445	130	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	Thermomicrobium roseum
29322574	29322574	PRJNA627467_P_NODE_6689_length_270_cov_4.357466_g6620_i0	PRJNA627467	6689	270	4.357466	11.7651582	Thermomicrobiales bacterium	2482790	Bacteria	Bacteria	79.3	1.56e-15	NR	MEA2595792.1	2482790	g6620	i0	61.8	0.844444444444444	76	29	84.4	0	260	33	2	77	MEA2595792.1 hypothetical protein [Thermomicrobiales bacterium]	diamond	228	79.3	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales			Thermomicrobiales bacterium
29638063	29638063	PRJNA627467_P_NODE_16270_length_167_cov_1.694915_g16201_i0	PRJNA627467	16270	167	1.694915	2.83050805	Thermomicrobiales bacterium	2482790	Bacteria	Bacteria	92.8	4.3e-21	NR	HLU34342.1	2482790	g16201	i0	90.7	0.970059880239521	54	5	97	0	164	3	32	85	HLU34342.1 cyanophycinase [Thermomicrobiales bacterium]	diamond	162	92.8	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales			Thermomicrobiales bacterium
29669608	29669608	PRJNA627467_P_NODE_11170_length_184_cov_1.162963_g11101_i0	PRJNA627467	11170	184	1.162963	2.13985192	Thermomicrobiales bacterium	2482790	Bacteria	Bacteria	73.2	5.12e-15	NR	HEV2074142.1	2482790	g11101	i0	58.3	1.94021739130435	60	25	97.8	0	182	3	9	68	HEV2074142.1 hypothetical protein [Thermomicrobiales bacterium]	diamond	357	73.2	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales			Thermomicrobiales bacterium
31787197	31787197	PRJNA627467_P_NODE_9957_length_188_cov_1.438849_g9888_i0	PRJNA627467	9957	188	1.438849	2.70503612	Thermomicrobiales bacterium	2482790	Bacteria	Bacteria	55.8	2.27e-7	NR	HLU36325.1	2482790	g9888	i0	53.8	0.829787234042553	52	21	83	1	29	184	4	52	HLU36325.1 GNAT family N-acetyltransferase [Thermomicrobiales bacterium]	diamond	156	55.8	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales			Thermomicrobiales bacterium
32420247	32420247	PRJNA627467_P_NODE_12499_length_179_cov_2.269231_g12430_i0	PRJNA627467	12499	179	2.269231	4.06192349	Thermomicrobiales bacterium	2482790	Bacteria	Bacteria	63.9	5.22e-10	NR	MDF3039105.1	2482790	g12430	i0	57.9	1.86033519553073	57	24	95.5	0	5	175	267	323	MDF3039105.1 UDP-N-acetylmuramyl-tripeptide synthetase [Thermomicrobiales bacterium]	diamond	333	63.9	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales			Thermomicrobiales bacterium
32767159	32767159	PRJNA627467_P_NODE_5620_length_316_cov_1.513109_g5552_i0	PRJNA627467	5620	316	1.513109	4.78142444	Thermomicrobiales bacterium	2482790	Bacteria	Bacteria	51.6	3.57e-6	NR	HWV25042.1	2482790	g5552	i0	74.2	0.569620253164557	31	8	29.4	0	309	217	12	42	HWV25042.1 DUF2795 domain-containing protein [Thermomicrobiales bacterium]	diamond	180	51.6	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales			Thermomicrobiales 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);;