metadata: contig_metadata: 11 rows where bioproject = "PRJNA393181", tax_kingdom = "Pseudomonadati" and tax

11 rows where bioproject = "PRJNA393181", 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
2961759	2961759	PRJNA393181_S_NODE_8583_length_409_cov_2.849462_g8477_i0	PRJNA393181	8583	409	2.849462	11.65429958	Thermomicrobiales bacterium	2482790	Bacteria	Bacteria	166	2.88e-45	NR	HYO29932.1	2482790	g8477	i0	59.3	3.09535452322738	140	53	99.8	1	2	409	198	337	HYO29932.1 LodA/GoxA family CTQ-dependent oxidase [Thermomicrobiales bacterium]	diamond	1266	166	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales			Thermomicrobiales bacterium
4237192	4237192	PRJNA393181_S_NODE_15584_length_304_cov_2.176030_g15478_i0	PRJNA393181	15584	304	2.17603	6.6151312	Thermomicrobiales bacterium	2482790	Bacteria	Bacteria	195	7.409999999999999e-57	NR	HEU5326587.1	2482790	g15478	i0	88.5	0.947368421052632	96	11	94.7	0	290	3	83	178	HEU5326587.1 CocE/NonD family hydrolase [Thermomicrobiales bacterium]	diamond	288	195	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales			Thermomicrobiales bacterium
9338193	9338193	PRJNA393181_S_NODE_14488_length_317_cov_1.896429_g14382_i0	PRJNA393181	14488	317	1.896429	6.01167993	Thermomicrobiales bacterium	2482790	Bacteria	Bacteria	119	1.05e-28	NR	HYO29932.1	2482790	g14382	i0	59.8	1.01261829652997	107	32	92.7	2	22	315	1	105	HYO29932.1 LodA/GoxA family CTQ-dependent oxidase [Thermomicrobiales bacterium]	diamond	321	119	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales			Thermomicrobiales bacterium
10006518	10006518	PRJNA393181_S_NODE_24888_length_230_cov_3.020725_g24782_i0	PRJNA393181	24888	230	3.020725	6.9476675	Thermomicrobiales bacterium	2482790	Bacteria	Bacteria	88.6	1.1e-18	NR	HEX5500557.1	2482790	g24782	i0	60.5	0.991304347826087	76	30	99.1	0	3	230	265	340	HEX5500557.1 isochorismatase family protein [Thermomicrobiales bacterium]	diamond	228	88.6	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales			Thermomicrobiales bacterium
14439898	14439898	PRJNA393181_S_NODE_9132_length_398_cov_2.559557_g9026_i0	PRJNA393181	9132	398	2.559557	10.18703686	Thermomicrobiales bacterium	2482790	Bacteria	Bacteria	147	1.06e-40	NR	HEU5328038.1	2482790	g9026	i0	62.1	2.32160804020101	103	39	77.6	0	2	310	183	285	HEU5328038.1 amidohydrolase family protein [Thermomicrobiales bacterium]	diamond	924	147	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales			Thermomicrobiales bacterium
16988144	16988144	PRJNA393181_S_NODE_37534_length_176_cov_3.165468_g37428_i0	PRJNA393181	37534	176	3.165468	5.57122368	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	62.1	2.47e-5	NTclustered	gi\|269787736\|gb\|CP001824.1\|	479434	g37428	i0	92.857	1.31818181818182	42	3	24	0	7	48	409713	409672	Sphaerobacter thermophilus DSM 20745 chromosome 2, complete sequence	blastn	232	62.1	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
25304406	25304406	PRJNA393181_S_NODE_10080_length_380_cov_2.676385_g9974_i0	PRJNA393181	10080	380	2.676385	10.170263	Thermomicrobiales bacterium	2482790	Bacteria	Bacteria	72.4	7.07e-12	NR	MEZ4569790.1	2482790	g9974	i0	40.7	1.06578947368421	135	68	97.9	4	373	2	275	408	MEZ4569790.1 ABC transporter permease subunit [Thermomicrobiales bacterium]	diamond	405	72.4	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales			Thermomicrobiales bacterium
26885672	26885672	PRJNA393181_S_NODE_41801_length_164_cov_1.811024_g41695_i0	PRJNA393181	41801	164	1.811024	2.97007936	Thermomicrobiales bacterium	2482790	Bacteria	Bacteria	74.3	3.91e-14	NR	HEU0116646.1	2482790	g41695	i0	65.4	1.86585365853659	52	17	95.1	1	163	8	219	269	HEU0116646.1 TIM barrel protein [Thermomicrobiales bacterium]	diamond	306	74.3	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales			Thermomicrobiales bacterium
27503048	27503048	PRJNA393181_S_NODE_23963_length_236_cov_2.326633_g23857_i0	PRJNA393181	23963	236	2.326633	5.49085388	Pseudomonadati	3379134	Bacteria	Bacteria	57	1.52e-7	NR	HEX5502477.1	2482790	g23857	i0	43.6	6.08898305084746	78	39	99.2	1	3	236	71	143	HEX5502477.1 ABATE domain-containing protein [Thermomicrobiales bacterium]	diamond	1437	57	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales			Thermomicrobiales bacterium
27612560	27612560	PRJNA393181_S_NODE_8444_length_412_cov_2.816000_g8338_i0	PRJNA393181	8444	412	2.816	11.60192	Thermomicrobiales bacterium	2482790	Bacteria	Bacteria	114	3.1e-26	NR	HEY7036591.1	2482790	g8338	i0	50.4	0.968446601941748	133	58	92.5	5	397	17	856	986	HEY7036591.1 N-acetylmuramoyl-L-alanine amidase [Thermomicrobiales bacterium]	diamond	399	114	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales			Thermomicrobiales bacterium
32414995	32414995	PRJNA393181_S_NODE_26819_length_220_cov_1.508197_g26713_i0	PRJNA393181	26819	220	1.508197	3.3180334	Thermomicrobiales bacterium	2482790	Bacteria	Bacteria	60.1	2.1e-8	NR	HEX3301592.1	2482790	g26713	i0	49.2	0.804545454545455	59	29	79.1	1	184	11	251	309	HEX3301592.1 FAD-binding oxidoreductase [Thermomicrobiales bacterium]	diamond	177	60.1	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);;