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

5 rows where bioproject = "PRJNA358009" and tax_phylum = "Deferribacterota"

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
1072991	1072991	PRJNA358009_P_NODE_17141_length_157_cov_7.129630_g17072_i0	PRJNA358009	17141	157	7.12963	11.1935191	Calditerrivibrio	545865	Bacteria	Bacteria	279	5.46e-71	NTclustered	gi\|470487186\|ref\|NR_076806.1\|	477976	g17072	i0	99.351	257.267515923567	154	1	98	0	3	156	482	635	Calditerrivibrio nitroreducens strain Yu37-1 23S ribosomal RNA gene, complete sequence	blastn	40391	279	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Calditerrivibrionaceae	Calditerrivibrio	Calditerrivibrio nitroreducens
15100722	15100722	PRJNA358009_P_NODE_12432_length_169_cov_4.050000_g12363_i0	PRJNA358009	12432	169	4.05	6.8445	Calditerrivibrio	545865	Bacteria	Bacteria	294	2.12e-75	NTclustered	gi\|470487186\|ref\|NR_076806.1\|	477976	g12363	i0	99.387	2.89349112426035	163	0	96	1	5	166	1441	1603	Calditerrivibrio nitroreducens strain Yu37-1 23S ribosomal RNA gene, complete sequence	blastn	489	294	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Calditerrivibrionaceae	Calditerrivibrio	Calditerrivibrio nitroreducens
18924534	18924534	PRJNA358009_P_NODE_8635_length_191_cov_7.316901_g8566_i0	PRJNA358009	8635	191	7.316901	13.97528091	Denitrovibrio	117999	Bacteria	Bacteria	289	1.1499999999999998e-73	NTclustered	gi\|470486080\|ref\|NR_076734.1\|	118000	g8566	i0	94.624	167.251308900524	186	10	97	0	6	191	1418	1233	Denitrovibrio acetiphilus strain N2460 23S ribosomal RNA gene, complete sequence	blastn	31945	289	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Geovibrionaceae	Denitrovibrio	Denitrovibrio acetiphilus
25299138	25299138	PRJNA358009_P_NODE_14900_length_163_cov_5.710526_g14831_i0	PRJNA358009	14900	163	5.710526	9.30815738	Calditerrivibrio	545865	Bacteria	Bacteria	289	9.51e-74	NTclustered	gi\|470487186\|ref\|NR_076806.1\|	477976	g14831	i0	100	118.368098159509	156	0	96	0	1	156	188	33	Calditerrivibrio nitroreducens strain Yu37-1 23S ribosomal RNA gene, complete sequence	blastn	19294	289	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Calditerrivibrionaceae	Calditerrivibrio	Calditerrivibrio nitroreducens
25299273	25299273	PRJNA358009_P_NODE_7980_length_212_cov_15.411043_g7911_i0	PRJNA358009	7980	212	15.411043	32.67141116	Denitrovibrio	117999	Bacteria	Bacteria	252	1.71e-62	NTclustered	gi\|470486080\|ref\|NR_076734.1\|	118000	g7911	i0	89.163	169.292452830189	203	20	95	2	4	204	2861	2659	Denitrovibrio acetiphilus strain N2460 23S ribosomal RNA gene, complete sequence	blastn	35890	252	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Geovibrionaceae	Denitrovibrio	Denitrovibrio acetiphilus

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