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

5 rows where bioproject = "PRJNA1047321" and tax_phylum = "Thermodesulfobacteriota"

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
174483	174483	PRJNA1047321_P_NODE_8881_length_236_cov_2.901840_g8710_i0	PRJNA1047321	8881	236	2.90184	6.8483424	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	265	2.5e-66	NTclustered	gi\|2893358409\|emb\|OZ220700.1\|	2202153	g8710	i0	86.92	150.237288135593	237	30	100	1	1	236	1520604	1520840	MAG: Thermodesulfobacteriota bacterium isolate c78cfef9-89c4-44c9-956d-f6b471e4c892 genome assembly, chromosome: 1	blastn	35456	265	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
1449132	1449132	PRJNA1047321_P_NODE_702_length_842_cov_3.394018_g593_i0	PRJNA1047321	702	842	3.394018	28.57763156	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	1038	0	NTclustered	gi\|2518551120\|emb\|OX638332.1\|	2080303	g593	i0	89.372	179.868171021378	828	84	98	3	8	833	22764	23589	MAG: Candidatus Dadabacteria bacterium isolate 28c7ac20-cd97-4a81-9be0-f5b43b5a8d2b genome assembly, chromosome: 1	blastn	151449	1038	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
27288097	27288097	PRJNA1047321_P_NODE_5963_length_261_cov_1.079787_g5792_i0	PRJNA1047321	5963	261	1.079787	2.81824407	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	43.1	0.0332	NR	MEW6501394.1	2202153	g5792	i0	41.7	0.551724137931034	48	28	55.2	0	206	63	341	388	MEW6501394.1 ABC transporter permease subunit [Thermodesulfobacteriota bacterium]	diamond	144	43.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
29592726	29592726	PRJNA1047321_P_NODE_7590_length_246_cov_0.890173_g7419_i0	PRJNA1047321	7590	246	0.890173	2.18982558	Citrifermentans bremense	60035	Bacteria	Bacteria	88.6	2.31e-18	NR	WP_026840625.1	60035	g7419	i0	86	1.82926829268293	50	7	61	0	152	3	1	50	WP_026840625.1 diguanylate cyclase [Citrifermentans bremense]	diamond	450	88.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Citrifermentans	Citrifermentans bremense
31646948	31646948	PRJNA1047321_P_NODE_6477_length_251_cov_0.865169_g6306_i0	PRJNA1047321	6477	251	0.865169	2.17157419	Geobacteraceae bacterium	2282154	Bacteria	Bacteria	157	1.6999999999999998e-44	NR	HTP66956.1	2282154	g6306	i0	81.9	0.99203187250996006	83	15	99.2	0	3	251	11	93	HTP66956.1 ISL3 family transposase [Geobacteraceae bacterium]	diamond	249	157	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae 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);;