metadata: contig_metadata: 9 rows where bioproject = "PRJEB48872" and tax

9 rows where bioproject = "PRJEB48872" 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
12844426	12844426	PRJEB48872_P_NODE_698111_length_150_cov_1.135135_g682299_i0	PRJEB48872	698111	150	1.135135	1.7027025	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	97.1	5.65e-22	NR	MCF8085469.1	2683721	g682299	i0	94	2	50	3	100	0	150	1	106	155	MCF8085469.1 FAD-binding protein [Desulfohalobiaceae bacterium]	diamond	300	97.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
16293478	16293478	PRJEB48872_P_NODE_594493_length_169_cov_2.892308_g578681_i0	PRJEB48872	594493	169	2.892308	4.88800052	Pseudomonadati	3379134	Bacteria	Bacteria	156	1.05e-33	NTclustered	gi\|2105309617\|dbj\|AP024485.1\|	2810563	g578681	i0	83.636	51.1420118343195	165	27	98	0	4	168	3531743	3531579	Pseudodesulfovibrio sediminis SF6 DNA, complete genome	blastn	8643	156	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio sediminis
22667730	22667730	PRJEB48872_P_NODE_688778_length_151_cov_2.196429_g672966_i0	PRJEB48872	688778	151	2.196429	3.31660779	Desulfurivibrio	427922	Bacteria	Bacteria	141	2.56e-29	NTclustered	gi\|470485970\|ref\|NR_076727.1\|	427923	g672966	i0	84	158.139072847682	150	21	99	3	1	149	327	474	Desulfurivibrio alkaliphilus strain AHT 2 23S ribosomal RNA gene, complete sequence	blastn	23879	141	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfurivibrio	Desulfurivibrio alkaliphilus
26590026	26590026	PRJEB48872_P_NODE_648781_length_159_cov_0.933333_g632969_i0	PRJEB48872	648781	159	0.933333	1.48399947	uncultured Desulfovibrio sp.	167968	Bacteria	Bacteria	41.2	0.042	NR	WP_300772992.1	167968	g632969	i0	40.9	0.830188679245283	44	26	83	0	21	152	1250	1293	WP_300772992.1 acyl-CoA dehydratase activase-related protein [uncultured Desulfovibrio sp.]	diamond	132	41.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	uncultured Desulfovibrio sp.
29268737	29268737	PRJEB48872_P_NODE_281229_length_302_cov_1.247148_g265417_i0	PRJEB48872	281229	302	1.247148	3.76638696	Thermodesulfobacteriota	200940	Bacteria	Bacteria	43.1	0.05	NR	MDD7476222.1	885	g265417	i0	34.7	1.22185430463576	72	44	71.5	1	87	302	187	255	MDD7476222.1 DotH/IcmK family type IV secretion protein [Desulfovibrio sp.]	diamond	369	43.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp.
29496658	29496658	PRJEB48872_P_NODE_694150_length_150_cov_2.801802_g678338_i0	PRJEB48872	694150	150	2.801802	4.202703	Smithella sp.	2053614	Bacteria	Bacteria	49.3	3.58e-5	NR	MEN6623685.1	2053614	g678338	i0	46.9	0.98	49	23	98	1	3	149	109	154	MEN6623685.1 N-6 DNA methylase [Smithella sp.]	diamond	147	49.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae	Smithella	Smithella sp.
29591000	29591000	PRJEB48872_P_NODE_575990_length_174_cov_1.155556_g560178_i0	PRJEB48872	575990	174	1.155556	2.01066744	Syntrophotalea acetylenica	29542	Bacteria	Bacteria	72.8	3.5e-13	NR	MDD4456268.1	29542	g560178	i0	50.9	0.982758620689655	57	28	98.3	0	2	172	30	86	MDD4456268.1 YqaJ viral recombinase family protein [Syntrophotalea acetylenica]	diamond	171	72.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Syntrophotaleaceae	Syntrophotalea	Syntrophotalea acetylenica
30311683	30311683	PRJEB48872_P_NODE_541112_length_182_cov_1.874126_g525300_i0	PRJEB48872	541112	182	1.874126	3.41090932	Pseudomonadati	3379134	Bacteria	Bacteria	79	1.85e-16	NR	WP_008869731.1	488939	g525300	i0	58.3	4.74725274725275	60	25	98.9	0	2	181	56	115	WP_008869731.1 hypothetical protein [Desulfonatronospira thiodismutans]	diamond	864	79.7	0.991217063989962	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfonatronovibrionaceae	Desulfonatronospira	Desulfonatronospira thiodismutans
31803361	31803361	PRJEB48872_P_NODE_622277_length_164_cov_0.984000_g606465_i0	PRJEB48872	622277	164	0.984	1.61376	Desulfovibrio piger	901	Bacteria	Bacteria	40	0.0226	NR	WP_072335524.1	901	g606465	i0	46.7	0.823170731707317	45	20	75	1	6	128	27	71	WP_072335524.1 helix-turn-helix domain-containing protein [Desulfovibrio piger]	diamond	135	40	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger

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