metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1126198" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1126198" 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
281810	281810	PRJNA1126198_P_NODE_481341_length_235_cov_2.253086_g480620_i0	PRJNA1126198	481341	235	2.253086	5.2947521	Pseudodesulfovibrio cashew	2678688	Bacteria	Bacteria	230	9.07e-56	NTclustered	gi\|1785261979\|gb\|CP046400.1\|	2678688	g480620	i0	92.547	73.6127659574468	161	11	70	1	1	161	2894859	2894700	Pseudodesulfovibrio cashew strain SRB007 chromosome, complete genome	blastn	17299	230	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio cashew
7408338	7408338	PRJNA1126198_P_NODE_452706_length_243_cov_1.835294_g451985_i0	PRJNA1126198	452706	243	1.835294	4.45976442	Desulfovibrionaceae	194924	Bacteria	Bacteria	259	1.2e-64	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g451985	i0	88.995	77.037037037037	209	23	86	0	35	243	3446965	3447173	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	18720	259	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
10485268	10485268	PRJNA1126198_P_NODE_462509_length_242_cov_2.497041_g461788_i0	PRJNA1126198	462509	242	2.497041	6.04283922	Desulfolutivibrio sulfoxidireducens	2773299	Bacteria	Bacteria	143	1.2599999999999998e-29	NTclustered	gi\|1863429635\|gb\|CP045508.1\|	2773299	g461788	i0	92.857	15.8553719008264	98	7	40	0	145	242	2339813	2339716	Desulfolutivibrio sulfoxidireducens strain DSM 107105 chromosome, complete genome	blastn	3837	143	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfolutivibrio	Desulfolutivibrio sulfoxidireducens
11759931	11759931	PRJNA1126198_P_NODE_282550_length_270_cov_1.182741_g281829_i0	PRJNA1126198	282550	270	1.182741	3.1934007	Desulfovibrio aminophilus	81425	Bacteria	Bacteria	189	1.8099999999999993e-43	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g281829	i0	81.818	14.0814814814815	231	36	84	3	6	233	3141556	3141783	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	3802	189	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
12508895	12508895	PRJNA1126198_P_NODE_129470_length_324_cov_1.143426_g128751_i0	PRJNA1126198	129470	324	1.143426	3.70470024	Candidatus Electrothrix	1859128	Bacteria	Bacteria	139	2.27e-28	NTclustered	gi\|2322424362\|emb\|OW818652.1\|	3036123	g128751	i0	97.531	25.4135802469136	81	2	25	0	197	277	4056503	4056583	Candidatus Electrothrix laxa isolate HOU-scMAG genome assembly, chromosome: 1	blastn	8234	139	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electrothrix	Candidatus Electrothrix laxa
14310216	14310216	PRJNA1126198_P_NODE_275032_length_272_cov_1.055276_g274311_i0	PRJNA1126198	275032	272	1.055276	2.87035072	Desulfofustis limnaeus	2740163	Bacteria	Bacteria	135	2.4100000000000003e-27	NTclustered	gi\|2211518257\|dbj\|AP025516.1\|	2740163	g274311	i0	90.291	53.1544117647059	103	10	38	0	114	216	1951522	1951624	Desulfobulbaceae bacterium PPLL DNA, complete genome	blastn	14458	135	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfofustis	Desulfofustis limnaeus
14310245	14310245	PRJNA1126198_P_NODE_289052_length_268_cov_1.594872_g288331_i0	PRJNA1126198	289052	268	1.594872	4.27425696	Desulfoluna limicola	2810562	Bacteria	Bacteria	209	1.38e-49	NTclustered	gi\|2158810072\|dbj\|AP024488.1\|	2810562	g288331	i0	91.503	20.5	153	12	57	1	3	155	5957558	5957407	Desulfoluna sp. ASN36 ASN36 DNA, complete genome	blastn	5494	209	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfolunaceae	Desulfoluna	Desulfoluna limicola
15584646	15584646	PRJNA1126198_P_NODE_458493_length_243_cov_0.917647_g457772_i0	PRJNA1126198	458493	243	0.917647	2.22988221	Desulfarculia bacterium	3065862	Bacteria	Bacteria	189	1.6e-43	NTclustered	gi\|2621702698\|emb\|OY759590.1\|	3065862	g457772	i0	83.744	552.975308641975	203	30	83	3	23	223	337109	337310	MAG: Desulfarculia bacterium isolate 49400898-fc5b-42b7-bef8-a303f8702bb8 genome assembly, chromosome: 1	blastn	134373	189	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia				Desulfarculia bacterium
16858469	16858469	PRJNA1126198_P_NODE_244994_length_279_cov_1.893204_g244273_i0	PRJNA1126198	244994	279	1.893204	5.28203916	Solidesulfovibrio carbinolicus	296842	Bacteria	Bacteria	294	3.87e-75	NTclustered	gi\|1566432249\|gb\|CP026538.1\|	296842	g244273	i0	85.714	94.0358422939068	280	38	100	2	1	279	1800280	1800558	Solidesulfovibrio carbinolicus strain DSM 3852 chromosome, complete genome	blastn	26236	294	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Solidesulfovibrio	Solidesulfovibrio carbinolicus
18133495	18133495	PRJNA1126198_P_NODE_468455_length_242_cov_0.923077_g467734_i0	PRJNA1126198	468455	242	0.923077	2.23384634	Candidatus Electrothrix laxa	3036123	Bacteria	Bacteria	62.1	3.62e-5	NTclustered	gi\|2322424362\|emb\|OW818652.1\|	3036123	g467734	i0	85.965	0.632231404958678	57	8	24	0	160	216	2281854	2281798	Candidatus Electrothrix laxa isolate HOU-scMAG genome assembly, chromosome: 1	blastn	153	62.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electrothrix	Candidatus Electrothrix laxa
20683113	20683113	PRJNA1126198_P_NODE_414477_length_247_cov_1.327586_g413756_i0	PRJNA1126198	414477	247	1.327586	3.27913742	Desulfovibrio aminophilus	81425	Bacteria	Bacteria	152	2.1399999999999998e-32	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g413756	i0	84.177	6.16194331983806	158	23	64	2	18	174	695593	695437	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	1522	152	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
21958584	21958584	PRJNA1126198_P_NODE_471618_length_242_cov_0.911243_g470897_i0	PRJNA1126198	471618	242	0.911243	2.20520806	Nitratidesulfovibrio sp. HK-II	2009266	Bacteria	Bacteria	154	5.81e-33	NTclustered	gi\|2791413552\|dbj\|AP036014.1\|	2009266	g470897	i0	78.099	3.95454545454545	242	53	100	0	1	242	2532068	2531827	Nitratidesulfovibrio sp. HK-II DNA, complete genome	blastn	957	154	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio sp. HK-II
23234016	23234016	PRJNA1126198_P_NODE_426939_length_246_cov_0.901734_g426218_i0	PRJNA1126198	426939	246	0.901734	2.21826564	Desulfatiglandales bacterium	3024416	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2621702716\|emb\|OY759599.1\|	3024416	g426218	i0	90.698	0.17479674796748	43	3	17	1	92	133	2786102	2786060	MAG: Desulfatiglandales bacterium isolate ef928343-fb2c-4ac1-bd77-a4af7a033044 genome assembly, chromosome: 1	blastn	43	56.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfatiglandales			Desulfatiglandales bacterium
24507373	24507373	PRJNA1126198_P_NODE_324420_length_260_cov_1.657754_g323699_i0	PRJNA1126198	324420	260	1.657754	4.3101604	Desulfovibrio aminophilus	81425	Bacteria	Bacteria	200	8e-47	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g323699	i0	81.667	20.4769230769231	240	44	92	0	21	260	3443879	3444118	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	5324	200	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus

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