metadata: contig_metadata: 5 rows where bioproject = "PRJNA611476" and tax

5 rows where bioproject = "PRJNA611476" 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
588890	588890	PRJNA611476_P_NODE_106681_length_244_cov_0.900585_g105890_i0	PRJNA611476	106681	244	0.900585	2.1974274	Rhodothermales bacterium	2306054	Bacteria	Bacteria	265	2.6e-66	NTclustered	gi\|2518550857\|emb\|OX638318.1\|	2306054	g105890	i0	86.667	143.758196721311	240	30	98	2	4	241	1466380	1466619	MAG: Rhodothermales bacterium isolate 55cba9af-49f2-4dbc-822e-66a085d3a702 genome assembly, chromosome: 1	blastn	35077	265	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
5693709	5693709	PRJNA611476_P_NODE_89245_length_248_cov_1.468571_g88454_i0	PRJNA611476	89245	248	1.468571	3.64205608	Rhodothermus marinus	29549	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|345111121\|gb\|CP003029.1\|	762570	g88454	i0	99.597	17.2943548387097	248	1	100	0	1	248	131713	131466	Rhodothermus marinus SG0.5JP17-172, complete genome	blastn	4289	453	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
9517806	9517806	PRJNA611476_P_NODE_42728_length_328_cov_1.862745_g41937_i0	PRJNA611476	42728	328	1.862745	6.1098036	Rhodocaloribacter	2893090	Bacteria	Bacteria	171	4.73e-49	NR	GIV60060.1	2026787	g41937	i0	72.5	2.99085365853659	109	30	99.7	0	328	2	41	149	GIV60060.1 MAG: hypothetical protein KatS3mg043_1149 [Rhodothermaceae bacterium]	diamond	981	171	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium
24816357	24816357	PRJNA611476_P_NODE_860_length_2211_cov_5.091674_g518_i0	PRJNA611476	860	2211	5.091674	112.57691214	Rhodothermus marinus	29549	Bacteria	Bacteria	749	4.3399999999999994e-263	NR	WP_012843110.1	29549	g518	i0	63.8	5.03120759837178	618	217	83.9	5	34	1887	1	611	WP_012843110.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Rhodothermus marinus]	diamond	11124	749	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
28185389	28185389	PRJNA611476_P_NODE_56026_length_292_cov_2.082192_g55235_i0	PRJNA611476	56026	292	2.082192	6.08000064	Rhodothermales bacterium	2306054	Bacteria	Bacteria	59.7	4.59e-8	NR	MBE2186445.1	2306054	g55235	i0	59.3	0.554794520547945	54	22	55.5	0	269	108	69	122	MBE2186445.1 PhzF family phenazine biosynthesis protein [Rhodothermales bacterium]	diamond	162	59.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales 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);;