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

5 rows where bioproject = "PRJNA682078" 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
2447883	2447883	PRJNA682078_P_NODE_196042_length_265_cov_1.604167_g194265_i0	PRJNA682078	196042	265	1.604167	4.25104255	Rhodothermales bacterium	2306054	Bacteria	Bacteria	170	5.56e-50	NR	MBE2185808.1	2306054	g194265	i0	90.7	0.973584905660377	86	8	97.4	0	263	6	214	299	MBE2185808.1 NAD-dependent epimerase/dehydratase family protein [Rhodothermales bacterium]	diamond	258	170	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
5764777	5764777	PRJNA682078_P_NODE_246125_length_248_cov_0.874286_g244348_i0	PRJNA682078	246125	248	0.874286	2.16822928	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	250	7.41e-62	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g244348	i0	85.417	43.1209677419355	240	35	97	0	1	240	1961606	1961845	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	10694	250	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
8314608	8314608	PRJNA682078_P_NODE_256387_length_246_cov_0.890173_g254610_i0	PRJNA682078	256387	246	0.890173	2.18982558	Rubrivirga marina	1196024	Bacteria	Bacteria	79.3	4.97e-15	NR	WP_095509916.1	1196024	g254610	i0	57.5	0.975609756097561	80	34	97.6	0	242	3	525	604	WP_095509916.1 hypothetical protein [Rubrivirga marina]	diamond	240	79.3	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga marina
12139578	12139578	PRJNA682078_P_NODE_206450_length_259_cov_1.634409_g204673_i0	PRJNA682078	206450	259	1.634409	4.23311931	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	278	3.58e-70	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g204673	i0	86.207	95.9227799227799	261	30	99	4	2	259	3252348	3252605	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	24844	278	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
21064187	21064187	PRJNA682078_P_NODE_265397_length_245_cov_0.895349_g263620_i0	PRJNA682078	265397	245	0.895349	2.19360505	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	239	1.5799999999999998e-58	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g263620	i0	85.778	2.40816326530612	225	32	92	0	21	245	433125	433349	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	590	239	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206

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