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

5 rows where bioproject = "PRJNA399133" 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
5516956	5516956	PRJNA399133_P_NODE_2265_length_330_cov_3.447458_g2177_i0	PRJNA399133	2265	330	3.447458	11.3766114	Desulfarculaceae bacterium	2528248	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|2621780225\|emb\|OY776512.1\|	2528248	g2177	i0	100	0.0848484848484849	28	0	8	0	127	154	5698994	5698967	MAG: Desulfarculaceae bacterium isolate e2237022-3439-453f-a1e0-3d3180ebaa11 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae		Desulfarculaceae bacterium
22089753	22089753	PRJNA399133_P_NODE_5518_length_225_cov_3.194737_g5430_i0	PRJNA399133	5518	225	3.194737	7.18815825	Geomonas paludis	2740185	Bacteria	Bacteria	209	1.12e-49	NTclustered	gi\|2233265061\|gb\|CP096574.1\|	2740185	g5430	i0	86	38.2177777777778	200	23	88	5	2	199	3098798	3098994	Geomonas paludis strain RG22 chromosome, complete genome	blastn	8599	209	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas paludis
29934343	29934343	PRJNA399133_P_NODE_5131_length_229_cov_1.881443_g5043_i0	PRJNA399133	5131	229	1.881443	4.30850447	Pseudomonadati	3379134	Bacteria	Bacteria	48.9	2.15e-4	NR	OGR15812.1	1797913	g5043	i0	43.4	1.96506550218341	76	41	99.6	1	2	229	917	990	OGR15812.1 MAG: hypothetical protein A2X81_08225 [Desulfobacterales bacterium GWB2_56_26]	diamond	450	48.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium GWB2_56_26
30991780	30991780	PRJNA399133_P_NODE_5214_length_229_cov_1.793814_g5126_i0	PRJNA399133	5214	229	1.793814	4.10783406	Desulfosalsimonas propionicica	332175	Bacteria	Bacteria	53.9	3.47e-6	NR	WP_220128375.1	332175	g5126	i0	100	0.62882096069869	24	0	31.4	0	74	3	718	741	WP_220128375.1 molybdopterin-dependent oxidoreductase [Desulfosalsimonas propionicica]	diamond	144	53.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosalsimonadaceae	Desulfosalsimonas	Desulfosalsimonas propionicica
32635886	32635886	PRJNA399133_P_NODE_340_length_917_cov_2.975057_g287_i0	PRJNA399133	340	917	2.975057	27.28127269	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	181	9.49e-53	NR	MDH3876401.1	2044940	g287	i0	57.8	0.588876772082879	180	70	58.9	3	723	184	11	184	MDH3876401.1 ERF family protein [Desulfobacterales bacterium]	diamond	540	181	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales 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);;