metadata: contig_metadata: 5 rows where bioproject = "PRJNA195897", tax_kingdom = "Pseudomonadati" and tax

5 rows where bioproject = "PRJNA195897", tax_kingdom = "Pseudomonadati" 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
28716211	28716211	PRJNA195897_P_NODE_4727_length_221_cov_0.906977_g4694_i0	PRJNA195897	4727	221	0.906977	2.00441917	Desulfobacterium sp.	2067988	Bacteria	Bacteria	49.3	2.04e-5	NR	MBA4369259.1	2067988	g4694	i0	62.2	0.502262443438914	37	14	50.2	0	2	112	1	37	MBA4369259.1 hypothetical protein [Desulfobacterium sp.]	diamond	111	49.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteriaceae	Desulfobacterium	Desulfobacterium sp.
30249955	30249955	PRJNA195897_P_NODE_7372_length_184_cov_1.155556_g7339_i0	PRJNA195897	7372	184	1.155556	2.12622304	Pseudomonadati	3379134	Bacteria	Bacteria	45.1	0.00248	NR	NJD90568.1	46610	g7339	i0	40.7	4.7445652173913	54	29	88	1	4	165	4	54	NJD90568.1 hypothetical protein [Geobacter sp.]	diamond	873	45.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp.
30691975	30691975	PRJNA195897_P_NODE_1233_length_478_cov_1.445221_g1202_i0	PRJNA195897	1233	478	1.445221	6.90815638	Pseudomonadati	3379134	Bacteria	Bacteria	183	7.5e-52	NR	HPA13822.1	2044940	g1202	i0	58.9	18.5146443514644	141	58	88.5	0	2	424	400	540	HPA13822.1 NADP-dependent glyceraldehyde-3-phosphate dehydrogenase [Desulfobacterales bacterium]	diamond	8850	184	0.994565217391304	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
30863767	30863767	PRJNA195897_P_NODE_4014_length_239_cov_1.368421_g3981_i0	PRJNA195897	4014	239	1.368421	3.27052619	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	71.6	2.17e-12	NR	MDJ0811845.1	2044940	g3981	i0	46.3	1.00418410041841	80	38	99.2	2	239	3	222	297	MDJ0811845.1 2-oxo acid dehydrogenase subunit E2 [Desulfobacterales bacterium]	diamond	240	71.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
32413613	32413613	PRJNA195897_P_NODE_7979_length_178_cov_0.984496_g7946_i0	PRJNA195897	7979	178	0.984496	1.75240288	Desulfovibrio litoralis	466107	Bacteria	Bacteria	45.4	0.00177	NR	WP_072697167.1	466107	g7946	i0	56.8	1.26404494382022	37	16	62.4	0	178	68	505	541	WP_072697167.1 ankyrin repeat domain-containing protein [Desulfovibrio litoralis]	diamond	225	45.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio litoralis

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