metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA615351" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA615351" and tax_phylum = "Rhodothermota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1871736	1871736	PRJNA615351_P_NODE_27142_length_1215_cov_3.303390_g19764_i0	PRJNA615351	27142	1215	3.30339	40.1361885	Pseudomonadati	3379134	Bacteria	Bacteria	494	5.979999999999999e-168	NR	WP_012843110.1	29549	g19764	i0	67.4	24.3382716049383	399	124	98.5	4	1	1197	219	611	WP_012843110.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Rhodothermus marinus]	diamond	29571	496	0.995967741935484	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
26985405	26985405	PRJNA615351_P_NODE_18402_length_1535_cov_3.866000_g13303_i0	PRJNA615351	18402	1535	3.866	59.3431	Rubrivirga sp. IMCC452	1885344	Bacteria	Bacteria	64.7	8.05e-7	NR	WP_412060949.1	3391614	g13303	i0	29.8	0.420195439739414	215	121	41.4	9	94	729	278	465	WP_412060949.1 AAA family ATPase [Rubrivirga sp. IMCC45206]	diamond	645	64.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
28880280	28880280	PRJNA615351_P_NODE_111588_length_275_cov_1.641667_g97489_i0	PRJNA615351	111588	275	1.641667	4.51458425	Rhodothermales bacterium	2306054	Bacteria	Bacteria	52.8	3.82e-6	NR	HLA63854.1	2306054	g97489	i0	45.6	1.25454545454545	57	30	62.2	1	12	182	77	132	HLA63854.1 LCCL domain-containing protein [Rhodothermales bacterium]	diamond	345	52.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
28911894	28911894	PRJNA615351_P_NODE_9528_length_2081_cov_6.041544_g6329_i1	PRJNA615351	9528	2081	6.041544	125.72453064	Salisaeta longa	503170	Bacteria	Bacteria	66.2	3.04e-7	NR	WP_051141322.1	503170	g6329	i1	27.1	0.387794329649207	269	164	36.5	11	47	805	6	258	WP_051141322.1 ATP-binding protein [Salisaeta longa]	diamond	807	66.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salisaetaceae	Salisaeta	Salisaeta longa
29038608	29038608	PRJNA615351_P_NODE_19208_length_1497_cov_3.400137_g13303_i1	PRJNA615351	19208	1497	3.400137	50.90005089	Rubrivirga sp. IMCC452	1885344	Bacteria	Bacteria	64.7	7.67e-7	NR	WP_412060949.1	3391614	g13303	i1	29.8	0.430861723446894	215	121	42.5	9	94	729	278	465	WP_412060949.1 AAA family ATPase [Rubrivirga sp. IMCC45206]	diamond	645	64.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
29480167	29480167	PRJNA615351_P_NODE_8870_length_2144_cov_5.735894_g6329_i0	PRJNA615351	8870	2144	5.735894	122.97756736	Salisaeta longa	503170	Bacteria	Bacteria	66.2	3.18e-7	NR	WP_051141322.1	503170	g6329	i0	27.1	0.376399253731343	269	164	35.4	11	47	805	6	258	WP_051141322.1 ATP-binding protein [Salisaeta longa]	diamond	807	66.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salisaetaceae	Salisaeta	Salisaeta longa
31357435	31357435	PRJNA615351_P_NODE_5036_length_2666_cov_17.095781_g732_i6	PRJNA615351	5036	2666	17.095781	455.77352146	root	1	Root_unresolved	Root_unresolved	120	8.05e-24	NR	MEF8797405.1	1885341	g732	i6	36.1	1.77906976744186	255	145	27.7	8	2573	1836	506	751	MEF8797405.1 IGHMBP2 family helicase [Salinivenus sp.]	diamond	4743	121	0.991735537190083	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinivenus	Salinivenus sp.
31389117	31389117	PRJNA615351_P_NODE_73696_length_471_cov_2.628440_g59723_i0	PRJNA615351	73696	471	2.62844	12.3799524	root	1	Root_unresolved	Root_unresolved	50.1	8.02e-4	NR	WP_095511576.1	1196024	g59723	i0	56.3	1.80891719745223	48	21	30.6	0	469	326	222	269	WP_095511576.1 diaminopimelate epimerase [Rubrivirga marina]	diamond	852	50.1	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga marina
31976973	31976973	PRJNA615351_P_NODE_23138_length_1344_cov_3.708174_g13303_i2	PRJNA615351	23138	1344	3.708174	49.83785856	Rubrivirga sp. IMCC452	1885344	Bacteria	Bacteria	65.5	3.43e-7	NR	WP_412060949.1	3391614	g13303	i2	29.8	0.479910714285714	215	121	47.3	9	245	880	278	465	WP_412060949.1 AAA family ATPase [Rubrivirga sp. IMCC45206]	diamond	645	65.5	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
32420063	32420063	PRJNA615351_P_NODE_186999_length_150_cov_1.730435_g172899_i0	PRJNA615351	186999	150	1.730435	2.5956525	Rhodothermia bacterium	2497633	Bacteria	Bacteria	62.8	5.62e-10	NR	MBT8400481.1	2497633	g172899	i0	59.2	0.98	49	20	98	0	147	1	42	90	MBT8400481.1 hypothetical protein [Rhodothermia bacterium]	diamond	147	62.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia				Rhodothermia bacterium
32609719	32609719	PRJNA615351_P_NODE_70840_length_494_cov_2.599129_g56934_i0	PRJNA615351	70840	494	2.599129	12.83969726	Rhodothermus sp.	2591385	Bacteria	Bacteria	66.2	3.17e-9	NR	MDQ7039768.1	2591385	g56934	i0	53.8	0.917004048582996	52	24	31.6	0	318	473	13	64	MDQ7039768.1 ATP-dependent DNA helicase RecQ [Rhodothermus sp.]	diamond	453	66.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus sp.

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