metadata: contig_metadata: 8 rows where bioproject = "PRJEB7799" and tax

8 rows where bioproject = "PRJEB7799" 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
25663584	25663584	PRJEB7799j_S_NODE_410_length_226_cov_3.324607_g405_i0	PRJEB7799	410	226	3.324607	7.51361182	Desulfatiglandales bacterium	3024416	Bacteria	Bacteria	73.1	1.54e-8	NTclustered	gi\|2621702716\|emb\|OY759599.1\|	3024416	g405	i0	91.071	0.743362831858407	56	2	24	3	156	210	6655243	6655190	MAG: Desulfatiglandales bacterium isolate ef928343-fb2c-4ac1-bd77-a4af7a033044 genome assembly, chromosome: 1	blastn	168	73.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfatiglandales			Desulfatiglandales bacterium
25889121	25889121	PRJEB7799m_S_NODE_699_length_221_cov_2.559140_g694_i0	PRJEB7799	699	221	2.55914	5.6556994	Desulfobacterales	213118	Bacteria	Bacteria	248	2.33e-61	NTclustered	gi\|218759244\|gb\|CP001322.1\|	218208	g694	i0	88.67	108.995475113122	203	23	92	0	1	203	4578799	4578597	Desulfatibacillum aliphaticivorans strain AK-01, complete genome	blastn	24088	250	0.992	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfatibacillaceae	Desulfatibacillum	Desulfatibacillum aliphaticivorans
26479289	26479289	PRJEB7799c_S_NODE_38056_length_151_cov_2.456897_g38033_i0	PRJEB7799	38056	151	2.456897	3.70991447	Pseudodesulfovibrio sp. zrk46	2725288	Bacteria	Bacteria	67.6	4.4e-7	NTclustered	gi\|1832582227\|gb\|CP051216.1\|	2725288	g38033	i0	91.667	9.15894039735099	48	4	32	0	4	51	1549082	1549035	Pseudodesulfovibrio sp. zrk46 chromosome, complete genome	blastn	1383	67.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio sp. zrk46
32999039	32999039	PRJEB7799n_S_NODE_6443_length_190_cov_2.425806_g6406_i0	PRJEB7799	6443	190	2.425806	4.6090314	Geobacter argillaceus	345631	Bacteria	Bacteria	93.6	4.3600000000000006e-21	NR	WP_145026094.1	345631	g6406	i0	64.5	0.978947368421053	62	22	97.9	0	186	1	82	143	WP_145026094.1 hypothetical protein [Geobacter argillaceus]	diamond	186	93.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter argillaceus
33128136	33128136	PRJEB7799l_S_NODE_3999_length_233_cov_1.338384_g3970_i0	PRJEB7799	3999	233	1.338384	3.11843472	Pseudomonadati	3379134	Bacteria	Bacteria	44.7	0.00691	NR	WP_027369199.1	873	g3970	i0	76.9	2.34334763948498	26	6	33.5	0	232	155	12	37	WP_027369199.1 EcoAI/FtnUII family type I restriction enzme subunit R [Desulfocurvibacter africanus]	diamond	546	45.1	0.991130820399113	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfocurvibacter	Desulfocurvibacter africanus
33128164	33128164	PRJEB7799n_S_NODE_8983_length_170_cov_2.829630_g8946_i0	PRJEB7799	8983	170	2.82963	4.810371	Pseudomonadati	3379134	Bacteria	Bacteria	45.1	0.00214	NR	WP_027369199.1	873	g8946	i0	74.1	3.33529411764706	27	7	47.6	0	169	89	11	37	WP_027369199.1 EcoAI/FtnUII family type I restriction enzme subunit R [Desulfocurvibacter africanus]	diamond	567	45.4	0.993392070484582	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfocurvibacter	Desulfocurvibacter africanus
33152668	33152668	PRJEB7799n_S_NODE_9864_length_164_cov_1.658915_g9827_i0	PRJEB7799	9864	164	1.658915	2.7206206	Thermodesulfatator atlanticus	501497	Bacteria	Bacteria	52	6.89e-6	NR	WP_169352780.1	501497	g9827	i0	61	2.26829268292683	41	16	75	0	164	42	410	450	WP_169352780.1 ATP-binding protein [Thermodesulfatator atlanticus]	diamond	372	52	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Thermodesulfobacteria	Thermodesulfobacteriales	Thermodesulfatatoraceae	Thermodesulfatator	Thermodesulfatator atlanticus
33179476	33179476	PRJEB7799p_S_NODE_11368_length_187_cov_2.947368_g11345_i0	PRJEB7799	11368	187	2.947368	5.51157816	Geobacter	28231	Bacteria	Bacteria	80.1	2.79e-16	NR	WP_039645128.1	28231	g11345	i0	63	5.98395721925134	54	20	86.6	0	187	26	118	171	WP_039645128.1 MULTISPECIES: class I SAM-dependent DNA methyltransferase [Geobacter]	diamond	1119	80.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter

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