metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA911178" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA911178" 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
4720265	4720265	PRJNA911178_P_NODE_157944_length_298_cov_1.337778_g155471_i0	PRJNA911178	157944	298	1.337778	3.98657844	Desulfuromonas soudanensis	1603606	Bacteria	Bacteria	248	3.2899999999999996e-61	NTclustered	gi\|924528553\|gb\|CP010802.1\|	1603606	g155471	i0	94.444	101.241610738255	162	7	54	1	91	250	2966742	2966903	Desulfuromonas soudanensis strain WTL chromosome, complete genome	blastn	30170	248	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas soudanensis
5077896	5077896	PRJNA911178_P_NODE_145464_length_309_cov_1.254237_g142991_i0	PRJNA911178	145464	309	1.254237	3.87559233	Geotalea	2910589	Bacteria	Bacteria	132	3.6e-26	NTclustered	gi\|221562406\|gb\|CP001390.1\|	316067	g142991	i0	85.6	4.20064724919094	125	18	40	0	79	203	2114134	2114258	Geobacter daltonii FRC-32, complete genome	blastn	1298	132	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geotalea	Geotalea daltonii
6353754	6353754	PRJNA911178_P_NODE_157305_length_298_cov_2.702222_g154832_i0	PRJNA911178	157305	298	2.702222	8.05262156	Pseudomonadati	3379134	Bacteria	Bacteria	134	9.61e-27	NTclustered	gi\|1841667704\|gb\|CP039543.1\|	370038	g154832	i0	93.333	15.3120805369128	90	6	30	0	73	162	4052372	4052283	Oceanidesulfovibrio marinus strain CS1 chromosome, complete genome	blastn	4563	134	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Oceanidesulfovibrio	Oceanidesulfovibrio marinus
8903111	8903111	PRJNA911178_P_NODE_267107_length_246_cov_0.890173_g264633_i0	PRJNA911178	267107	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	283	7.239999999999999e-72	NTclustered	gi\|779731694\|gb\|CP010430.1\|	35554	g264633	i0	87.917	382.459349593496	240	29	98	0	7	246	2784473	2784712	Geobacter sulfurreducens strain AM-1 genome	blastn	94085	283	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
8903190	8903190	PRJNA911178_P_NODE_288407_length_242_cov_0.911243_g285933_i0	PRJNA911178	288407	242	0.911243	2.20520806	Oleidesulfovibrio	2909705	Bacteria	Bacteria	110	1.28e-19	NTclustered	gi\|470477329\|ref\|NR_076377.1\|	58180	g285933	i0	75.82	12.3801652892562	244	44	98	15	1	236	488	252	Desulfovibrio alaskensis strain G20 23S ribosomal RNA gene, complete sequence	blastn	2996	110	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Oleidesulfovibrio	Oleidesulfovibrio alaskensis
11095915	11095915	PRJNA911178_P_NODE_233329_length_254_cov_1.679558_g230855_i0	PRJNA911178	233329	254	1.679558	4.26607732	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	466	6.95e-127	NTclustered	gi\|2022650692\|gb\|CP072608.1\|	876	g230855	i0	100	209.984251968504	252	0	99	0	1	252	2536365	2536114	Desulfovibrio desulfuricans strain L4 chromosome, complete genome	blastn	53336	466	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
11096572	11096572	PRJNA911178_P_NODE_36009_length_570_cov_1.054326_g33627_i0	PRJNA911178	36009	570	1.054326	6.0096582	Desulfuromonas sp. DDH964	1823759	Bacteria	Bacteria	429	2.22e-115	NTclustered	gi\|1015516084\|gb\|CP015080.1\|	1823759	g33627	i0	80.796	694.661403508772	578	85	99	20	1	569	2846848	2847408	Desulfuromonas sp. DDH964 chromosome, complete genome	blastn	395957	429	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas sp. DDH964
12370981	12370981	PRJNA911178_P_NODE_175890_length_285_cov_2.132075_g173417_i0	PRJNA911178	175890	285	2.132075	6.07641375	Desulfoferula mesophila	3058419	Bacteria	Bacteria	296	1.0999999999999999e-75	NTclustered	gi\|2619692108\|dbj\|AP028679.1\|	3058419	g173417	i0	85.614	285.438596491228	285	37	99	4	3	285	78128	78410	Desulfoferula mesophila 12FAK DNA, complete genome	blastn	81350	296	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae	Desulfoferula	Desulfoferula mesophila
17470555	17470555	PRJNA911178_P_NODE_226574_length_257_cov_3.853261_g224100_i0	PRJNA911178	226574	257	3.853261	9.90288077	Candidatus Electronema aureum	2005002	Bacteria	Bacteria	93.5	1.38e-14	NTclustered	gi\|2322424202\|emb\|OW818638.1\|	2005002	g224100	i0	77.586	1.85992217898833	174	25	65	11	77	243	318969	318803	Candidatus Electronema aureum isolate ENR-cMAG genome assembly, chromosome: 1	blastn	478	93.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electronema	Candidatus Electronema aureum
22568985	22568985	PRJNA911178_P_NODE_173458_length_287_cov_1.172897_g170985_i0	PRJNA911178	173458	287	1.172897	3.36621439	uncultured Desulfosarcina sp.	218289	Bacteria	Bacteria	158	5.47e-34	NTclustered	gi\|2621713517\|emb\|OY771548.1\|	218289	g170985	i0	79.151	142.191637630662	259	31	84	17	3	242	92750	92496	MAG: uncultured Desulfosarcina sp. isolate c75788b4-9dc9-432e-af07-dc879bdb42fc genome assembly, chromosome: 1	blastn	40809	158	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	uncultured Desulfosarcina sp.
25119400	25119400	PRJNA911178_P_NODE_61400_length_446_cov_3.646113_g58950_i0	PRJNA911178	61400	446	3.646113	16.26166398	Desulfatibacillum aliphaticivorans	218208	Bacteria	Bacteria	95.3	7.07e-15	NTclustered	gi\|218759244\|gb\|CP001322.1\|	218208	g58950	i0	93.75	2.51121076233184	64	3	14	1	294	356	4327335	4327398	Desulfatibacillum aliphaticivorans strain AK-01, complete genome	blastn	1120	95.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfatibacillaceae	Desulfatibacillum	Desulfatibacillum aliphaticivorans
25476160	25476160	PRJNA911178_P_NODE_124920_length_329_cov_1.792969_g122448_i0	PRJNA911178	124920	329	1.792969	5.89886801	Geomonas	2651583	Bacteria	Bacteria	394	4.47e-105	NTclustered	gi\|2233265061\|gb\|CP096574.1\|	2740185	g122448	i0	88.82	213.139817629179	322	34	98	2	9	329	885810	886130	Geomonas paludis strain RG22 chromosome, complete genome	blastn	70123	394	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas paludis
25476783	25476783	PRJNA911178_P_NODE_256560_length_248_cov_0.880000_g254086_i0	PRJNA911178	256560	248	0.88	2.1824	Desulfovibrio	872	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|2220256551\|gb\|ON183261.1\|	876	g254086	i0	99.592	100.802419354839	245	1	99	0	1	245	312	68	Desulfovibrio desulfuricans strain Essex 6 16S ribosomal RNA gene, partial sequence	blastn	24999	448	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans

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