metadata: contig_metadata: 7 rows where bioproject = "PRJNA1159911" and tax

7 rows where bioproject = "PRJNA1159911" 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
13791292	13791292	PRJNA1159911_P_NODE_69231_length_285_cov_2.349057_g68689_i0	PRJNA1159911	69231	285	2.349057	6.69481245	Desulfarculus	453229	Bacteria	Bacteria	141	5.46e-29	NTclustered	gi\|301638057\|gb\|CP002085.1\|	644282	g68689	i0	83.125	44.821052631579	160	21	54	4	113	266	830874	831033	Desulfarculus baarsii DSM 2075, complete genome	blastn	12774	141	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae	Desulfarculus	Desulfarculus baarsii
16884704	16884704	PRJNA1159911_P_NODE_354_length_8846_cov_4.847373_g350_i0	PRJNA1159911	354	8846	4.847373	428.79861558	Geopsychrobacteraceae bacterium	3065857	Bacteria	Bacteria	1661	0	NTclustered	gi\|2621701823\|emb\|OY759353.1\|	3065857	g350	i0	82.595	3.73411711508026	1896	316	21	7	2934	4816	4680086	4681980	MAG: Geopsychrobacteraceae bacterium isolate b20cad9c-d1d2-40c5-8f7b-178437520c26 genome assembly, chromosome: 1	blastn	33032	1661	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geopsychrobacteraceae		Geopsychrobacteraceae bacterium
23260746	23260746	PRJNA1159911_P_NODE_81999_length_259_cov_1.451613_g81457_i0	PRJNA1159911	81999	259	1.451613	3.75967767	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	215	2.84e-51	NTclustered	gi\|2621717821\|emb\|OY776218.1\|	2044940	g81457	i0	82.213	2.51351351351351	253	41	97	4	2	252	2792851	2793101	MAG: Desulfobacterales bacterium isolate b599e3c4-2ca3-45e6-bc7f-bb04c01707dc genome assembly, chromosome: 1	blastn	651	215	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
27893136	27893136	PRJNA1159911_P_NODE_92945_length_247_cov_0.885057_g92403_i0	PRJNA1159911	92945	247	0.885057	2.18609079	Smithella sp. F21	1538640	Bacteria	Bacteria	143	5.9e-38	NR	KFN37787.1	1538640	g92403	i0	84.1	0.995951417004049	82	13	99.6	0	247	2	284	365	KFN37787.1 hypothetical protein KN63_08110 [Smithella sp. F21]	diamond	246	143	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae	Smithella	Smithella sp. F21
28146047	28146047	PRJNA1159911_P_NODE_685_length_4721_cov_4.652754_g659_i0	PRJNA1159911	685	4721	4.652754	219.65651634	Syntrophotalea acetylenica	29542	Bacteria	Bacteria	307	2.2599999999999997e-88	NR	MDD4456620.1	29542	g659	i0	40.8	0.284685447998305	448	244	28.2	8	2018	687	28	458	MDD4456620.1 ATPase, T2SS/T4P/T4SS family [Syntrophotalea acetylenica]	diamond	1344	307	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Syntrophotaleaceae	Syntrophotalea	Syntrophotalea acetylenica
30640538	30640538	PRJNA1159911_P_NODE_2133_length_2464_cov_4.903388_g2023_i0	PRJNA1159911	2133	2464	4.903388	120.81948032	uncultured Desulfuromusa sp.	219183	Bacteria	Bacteria	202	9.49e-51	NR	WP_321392226.1	219183	g2023	i0	30.5	0.566152597402597	465	292	53.8	10	2433	1108	282	738	WP_321392226.1 DotA/TraY family protein [uncultured Desulfuromusa sp.]	diamond	1395	202	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geopsychrobacteraceae	Desulfuromusa	uncultured Desulfuromusa sp.
31747049	31747049	PRJNA1159911_P_NODE_95637_length_245_cov_0.895349_g95095_i0	PRJNA1159911	95637	245	0.895349	2.19360505	Candidatus Electrothrix aestuarii	3062594	Bacteria	Bacteria	63.2	2.47e-9	NR	XCN75363.1	3062594	g95095	i0	44.3	2.20408163265306	61	33	73.5	1	184	5	956	1016	XCN75363.1 MAG: WD40 repeat domain-containing protein [Candidatus Electrothrix aestuarii]	diamond	540	63.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electrothrix	Candidatus Electrothrix aestuarii

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