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

14 rows where analysis = "blastn", bioproject = "PRJNA758088" 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
3289067	3289067	PRJNA758088_P_NODE_347623_length_243_cov_0.905882_g340652_i0	PRJNA758088	347623	243	0.905882	2.20129326	Desulfovibrio piger	901	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1102127722\|emb\|LT630450.1\|	901	g340652	i0	100	47.0905349794239	243	0	100	0	1	243	851536	851778	Desulfovibrio piger isolate FI11049 genome assembly, chromosome: I	blastn	11443	449	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
5841166	5841166	PRJNA758088_P_NODE_339165_length_244_cov_0.900585_g332194_i0	PRJNA758088	339165	244	0.900585	2.1974274	Desulfovibrio piger	901	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g332194	i0	100	157.438524590164	244	0	100	0	1	244	2349579	2349822	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	38415	451	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
7115677	7115677	PRJNA758088_P_NODE_292166_length_250_cov_0.870056_g285195_i0	PRJNA758088	292166	250	0.870056	2.17514	Desulfovibrio piger	901	Bacteria	Bacteria	279	9.54e-71	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g285195	i0	87.008	9.232	254	25	100	7	1	250	963436	963685	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	2308	279	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
7116595	7116595	PRJNA758088_P_NODE_351386_length_243_cov_0.870588_g344415_i0	PRJNA758088	351386	243	0.870588	2.11552884	uncultured Mailhella sp.	1981031	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|2729058701\|emb\|OZ007001.1\|	1981031	g344415	i0	99.177	2	243	2	100	0	1	243	1178663	1178905	MAG: uncultured Mailhella sp. isolate metabat2_pooled_hifiasm.920 MAG genome assembly, chromosome: 1	blastn	486	438	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Mailhella	uncultured Mailhella sp.
7581763	7581763	PRJNA758088_P_NODE_328686_length_245_cov_0.895349_g321715_i0	PRJNA758088	328686	245	0.895349	2.19360505	Desulfomicrobium	898	Bacteria	Bacteria	420	5.26e-113	NTclustered	gi\|470484403\|ref\|NR_076646.1\|	899	g321715	i0	97.551	198.926530612245	245	6	100	0	1	245	88	332	Desulfomicrobium baculatum strain INMI strain X 23S ribosomal RNA gene, complete sequence	blastn	48737	420	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium baculatum
12215253	12215253	PRJNA758088_P_NODE_207410_length_296_cov_0.852018_g200439_i0	PRJNA758088	207410	296	0.852018	2.52197328	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	370	6.68e-98	NTclustered	gi\|1621566608\|gb\|CP036295.1\|	876	g200439	i0	89.456	236.057432432432	294	29	100	2	4	296	493455	493163	Desulfovibrio desulfuricans strain IC1 chromosome, complete genome	blastn	69873	370	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
13490581	13490581	PRJNA758088_P_NODE_283171_length_251_cov_0.865169_g276200_i0	PRJNA758088	283171	251	0.865169	2.17157419	Desulfovibrio piger	901	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g276200	i0	99.602	1.30677290836653	251	1	100	0	1	251	1426006	1426256	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	328	459	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
14763303	14763303	PRJNA758088_P_NODE_120992_length_381_cov_1.977273_g114022_i0	PRJNA758088	120992	381	1.977273	7.53341013	Smithellaceae bacterium	2964540	Bacteria	Bacteria	592	1.7299999999999996e-164	NTclustered	gi\|2626216295\|emb\|OY821638.1\|	2964540	g114022	i0	98.795	158.62467191601	332	4	100	0	50	381	4512152	4511821	MAG: Smithellaceae bacterium isolate 7d888188-1d27-4603-a379-950c855845c6 genome assembly, chromosome: 1	blastn	60436	592	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae		Smithellaceae bacterium
14765497	14765497	PRJNA758088_P_NODE_266092_length_259_cov_1.241935_g259121_i0	PRJNA758088	266092	259	1.241935	3.21661165	Desulfovibrio piger	901	Bacteria	Bacteria	462	9.2e-126	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g259121	i0	98.842	1.98841698841699	259	3	100	0	1	259	1651903	1651645	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	515	462	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
14766748	14766748	PRJNA758088_P_NODE_351232_length_243_cov_0.888235_g344261_i0	PRJNA758088	351232	243	0.888235	2.15841105	Desulfovibrio fairfieldensis	44742	Bacteria	Bacteria	405	1.46e-108	NTclustered	gi\|987453195\|gb\|CP014229.1\|	44742	g344261	i0	97.083	0.987654320987654	240	7	99	0	4	243	2024132	2023893	Desulfovibrio fairfieldensis strain CCUG 45958 chromosome, complete genome	blastn	240	405	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio fairfieldensis
17316600	17316600	PRJNA758088_P_NODE_49934_length_630_cov_2.700180_g43220_i0	PRJNA758088	49934	630	2.70018	17.011134	Smithellaceae bacterium	2964540	Bacteria	Bacteria	979	0	NTclustered	gi\|2626214512\|emb\|OY820932.1\|	2964540	g43220	i0	94.77	184.950793650794	631	29	99	4	1	628	849755	850384	MAG: Smithellaceae bacterium isolate 90efb5c7-b315-4df1-98b9-9b59cc098579 genome assembly, chromosome: 1	blastn	116519	979	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae		Smithellaceae bacterium
18589738	18589738	PRJNA758088_P_NODE_363215_length_241_cov_0.916667_g356244_i0	PRJNA758088	363215	241	0.916667	2.20916747	Desulfovibrio piger	901	Bacteria	Bacteria	435	1.84e-117	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g356244	i0	99.17	2.98340248962656	241	2	100	0	1	241	1456244	1456484	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	719	435	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
23689743	23689743	PRJNA758088_P_NODE_280879_length_251_cov_0.865169_g273908_i0	PRJNA758088	280879	251	0.865169	2.17157419	Nitratidesulfovibrio liaohensis	2604158	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|2575677524\|gb\|CP133659.1\|	2604158	g273908	i0	99.602	348.175298804781	251	1	100	0	1	251	1255158	1254908	Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome	blastn	87392	459	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio liaohensis
25429707	25429707	PRJNA758088_P_NODE_148360_length_346_cov_1.117216_g141389_i0	PRJNA758088	148360	346	1.117216	3.86556736	Desulfobulbus	893	Bacteria	Bacteria	590	5.609999999999999e-164	NTclustered	gi\|470487339\|ref\|NR_076814.1\|	894	g141389	i0	97.406	237.49710982659	347	7	100	2	1	346	164	509	Desulfobulbus propionicus strain 1pr3 23S ribosomal RNA gene, complete sequence	blastn	82174	590	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus propionicus

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