metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA688352" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA688352" 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
1176834	1176834	PRJNA688352_P_NODE_8381_length_249_cov_0.875000_g8278_i0	PRJNA688352	8381	249	0.875	2.17875	Desulfovibrionaceae	194924	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1566432249\|gb\|CP026538.1\|	296842	g8278	i0	100	0.582329317269076	29	0	12	0	213	241	1457527	1457555	Solidesulfovibrio carbinolicus strain DSM 3852 chromosome, complete genome	blastn	145	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Solidesulfovibrio	Solidesulfovibrio carbinolicus
3217819	3217819	PRJNA688352_P_NODE_8403_length_249_cov_0.875000_g8300_i0	PRJNA688352	8403	249	0.875	2.17875	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	305	1.57e-78	NTclustered	gi\|2381092847\|gb\|CP113000.1\|	2202153	g8300	i0	90.476	1.04417670682731	231	22	93	0	2	232	1462660	1462890	MAG: Thermodesulfobacteriota bacterium isolate ORM2a chromosome, complete genome	blastn	260	305	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
4494793	4494793	PRJNA688352_P_NODE_3484_length_334_cov_1.111111_g3381_i0	PRJNA688352	3484	334	1.111111	3.71111074	Syntrophotalea carbinolica	19	Bacteria	Bacteria	97.1	1.43e-15	NTclustered	gi\|90823168\|gb\|CP000142.2\|	338963	g3381	i0	75.688	42.188622754491	218	39	64	13	22	232	1139797	1140007	Pelobacter carbinolicus DSM 2380, complete genome	blastn	14091	97.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Syntrophotaleaceae	Syntrophotalea	Syntrophotalea carbinolica
4494860	4494860	PRJNA688352_P_NODE_9824_length_246_cov_0.890173_g9721_i0	PRJNA688352	9824	246	0.890173	2.18982558	Geoalkalibacter halelectricus	2847045	Bacteria	Bacteria	156	1.65e-33	NTclustered	gi\|2304895958\|gb\|CP092109.1\|	2847045	g9721	i0	83.735	2.76829268292683	166	25	67	2	1	165	843665	843501	Geoalkalibacter halelectricus strain SAP-1 chromosome	blastn	681	156	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geoalkalibacteraceae	Geoalkalibacter	Geoalkalibacter halelectricus
8320083	8320083	PRJNA688352_P_NODE_9387_length_247_cov_0.885057_g9284_i0	PRJNA688352	9387	247	0.885057	2.18609079	Desulfosarcina widdelii	947919	Bacteria	Bacteria	167	7.64e-37	NTclustered	gi\|1773416083\|dbj\|AP021875.1\|	947919	g9284	i0	81.592	0.813765182186235	201	37	81	0	40	240	5114839	5115039	Desulfosarcina widdelii PP31 DNA, complete genome	blastn	201	167	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	Desulfosarcina widdelii
10870900	10870900	PRJNA688352_P_NODE_12389_length_241_cov_0.916667_g12286_i0	PRJNA688352	12389	241	0.916667	2.20916747	Desulfobulbus propionicus	894	Bacteria	Bacteria	305	1.51e-78	NTclustered	gi\|320120648\|gb\|CP002364.1\|	577650	g12286	i0	90.476	88.1410788381743	231	22	96	0	1	231	2222778	2222548	Desulfobulbus propionicus DSM 2032, complete genome	blastn	21242	305	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus propionicus
12146286	12146286	PRJNA688352_P_NODE_7090_length_251_cov_0.865169_g6987_i0	PRJNA688352	7090	251	0.865169	2.17157419	Geoalkalibacter subterraneus	483547	Bacteria	Bacteria	178	3.6e-40	NTclustered	gi\|749207097\|gb\|CP010311.1\|	483547	g6987	i0	79.92	3.56972111553785	249	45	99	4	1	248	2853078	2852834	Geoalkalibacter subterraneus strain Red1, complete genome	blastn	896	178	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geoalkalibacteraceae	Geoalkalibacter	Geoalkalibacter subterraneus
12146298	12146298	PRJNA688352_P_NODE_8510_length_248_cov_0.880000_g8407_i0	PRJNA688352	8510	248	0.88	2.1824	Syntrophus buswellii	43774	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2869717242\|gb\|CP175563.1\|	43774	g8407	i0	100	1.93145161290323	248	0	100	0	1	248	3054161	3053914	Syntrophus buswellii strain DM-2 chromosome, complete genome	blastn	479	459	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae	Syntrophus	Syntrophus buswellii
13420793	13420793	PRJNA688352_P_NODE_10091_length_245_cov_0.895349_g9988_i0	PRJNA688352	10091	245	0.895349	2.19360505	Desulfococcus multivorans	897	Bacteria	Bacteria	104	6.02e-18	NTclustered	gi\|1092202713\|gb\|CP015381.1\|	897	g9988	i0	88.372	1.01632653061224	86	10	35	0	160	245	1407379	1407464	Desulfococcus multivorans strain DSM 2059 chromosome, complete genome	blastn	249	104	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfococcus	Desulfococcus multivorans
13420825	13420825	PRJNA688352_P_NODE_12331_length_241_cov_0.916667_g12228_i0	PRJNA688352	12331	241	0.916667	2.20916747	Geobacter pickeringii	345632	Bacteria	Bacteria	191	4.41e-44	NTclustered	gi\|747129828\|gb\|CP009788.1\|	345632	g12228	i0	80.913	8.46473029045643	241	46	100	0	1	241	6798	6558	Geobacter pickeringii strain G13, complete genome	blastn	2040	191	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter pickeringii
22344231	22344231	PRJNA688352_P_NODE_8178_length_249_cov_0.875000_g8075_i0	PRJNA688352	8178	249	0.875	2.17875	Desulfoferula mesophila	3058419	Bacteria	Bacteria	174	4.61e-39	NTclustered	gi\|2619692108\|dbj\|AP028679.1\|	3058419	g8075	i0	81.69	5.6706827309237	213	35	85	4	1	211	571863	572073	Desulfoferula mesophila 12FAK DNA, complete genome	blastn	1412	174	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae	Desulfoferula	Desulfoferula mesophila
23619688	23619688	PRJNA688352_P_NODE_11479_length_243_cov_0.870588_g11376_i0	PRJNA688352	11479	243	0.870588	2.11552884	Desulfopila sp. IMCC35008	2653858	Bacteria	Bacteria	226	1.2199999999999999e-54	NTclustered	gi\|2557433592\|gb\|CP050700.1\|	2653858	g11376	i0	83.682	0.983539094650206	239	39	98	0	1	239	2907027	2906789	Desulfopila sp. IMCC35008 chromosome, complete genome	blastn	239	226	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfopila	Desulfopila sp. IMCC35008

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