metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1120203" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA1120203" 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
5378306	5378306	PRJNA1120203_P_NODE_66385_length_276_cov_1.374384_g65369_i0	PRJNA1120203	66385	276	1.374384	3.79329984	Desulfovibrio piger	901	Bacteria	Bacteria	499	7.54e-137	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g65369	i0	99.275	2.30434782608696	276	2	100	0	1	276	1829541	1829266	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	636	499	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
5378487	5378487	PRJNA1120203_P_NODE_79405_length_251_cov_0.865169_g78389_i0	PRJNA1120203	79405	251	0.865169	2.17157419	Desulfovibrio piger	901	Bacteria	Bacteria	263	9.65e-66	NTclustered	gi\|1102127722\|emb\|LT630450.1\|	901	g78389	i0	86.475	1.97211155378486	244	27	97	4	8	251	663604	663367	Desulfovibrio piger isolate FI11049 genome assembly, chromosome: I	blastn	495	263	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
6130723	6130723	PRJNA1120203_P_NODE_48805_length_323_cov_4.056000_g47789_i0	PRJNA1120203	48805	323	4.056	13.10088	Pseudomonadati	3379134	Bacteria	Bacteria	185	2.87e-42	NTclustered	gi\|2891482193\|emb\|OZ219926.1\|	2202153	g47789	i0	91.241	134.157894736842	137	11	42	1	14	149	773857	773993	MAG: Thermodesulfobacteriota bacterium isolate 21442c6b-cc68-4f82-8039-a5361455a999 genome assembly, chromosome: 3	blastn	43333	185	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
8680875	8680875	PRJNA1120203_P_NODE_26707_length_467_cov_8.588832_g25693_i0	PRJNA1120203	26707	467	8.588832	40.10984544	Pseudomonadati	3379134	Bacteria	Bacteria	279	1.91e-70	NTclustered	gi\|2046988434\|gb\|MZ317661.1\|	885	g25693	i0	100	54.2526766595289	151	0	62	0	3	153	461	611	Desulfovibrio sp. strain 15A 16S ribosomal RNA gene, partial sequence	blastn	25336	279	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp.
9202484	9202484	PRJNA1120203_P_NODE_104768_length_241_cov_0.916667_g103752_i0	PRJNA1120203	104768	241	0.916667	2.20916747	Desulfovibrio piger	901	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g103752	i0	99.585	400.829875518672	241	1	100	0	1	241	761112	761352	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	96600	440	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
10479025	10479025	PRJNA1120203_P_NODE_78929_length_251_cov_0.865169_g77913_i0	PRJNA1120203	78929	251	0.865169	2.17157419	Desulfoferula mesophila	3058419	Bacteria	Bacteria	339	1.56e-88	NTclustered	gi\|2619692108\|dbj\|AP028679.1\|	3058419	g77913	i0	91.463	0.9800796812749	246	21	98	0	6	251	2900774	2900529	Desulfoferula mesophila 12FAK DNA, complete genome	blastn	246	339	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae	Desulfoferula	Desulfoferula mesophila
10479277	10479277	PRJNA1120203_P_NODE_94809_length_245_cov_0.895349_g93793_i0	PRJNA1120203	94809	245	0.895349	2.19360505	Desulfovibrio piger	901	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1102127722\|emb\|LT630450.1\|	901	g93793	i0	100	2	245	0	100	0	1	245	1067057	1067301	Desulfovibrio piger isolate FI11049 genome assembly, chromosome: I	blastn	490	453	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
14303328	14303328	PRJNA1120203_P_NODE_100312_length_243_cov_0.905882_g99296_i0	PRJNA1120203	100312	243	0.905882	2.20129326	Desulfovibrio piger	901	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g99296	i0	100	2	243	0	100	0	1	243	2458686	2458928	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	486	449	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
14304056	14304056	PRJNA1120203_P_NODE_66352_length_276_cov_1.438424_g65336_i0	PRJNA1120203	66352	276	1.438424	3.97005024	Desulfovibrio piger	901	Bacteria	Bacteria	505	1.62e-138	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g65336	i0	99.638	2.11231884057971	276	1	100	0	1	276	1799283	1799008	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	583	505	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
15578246	15578246	PRJNA1120203_P_NODE_82073_length_250_cov_0.870056_g81057_i0	PRJNA1120203	82073	250	0.870056	2.17514	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|2108083302\|gb\|CP070746.1\|	2044940	g81057	i0	99.6	3.276	250	1	100	0	1	250	1050336	1050087	MAG: Desulfobacterales bacterium isolate bin36 chromosome	blastn	819	457	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
15578393	15578393	PRJNA1120203_P_NODE_91693_length_246_cov_0.890173_g90677_i0	PRJNA1120203	91693	246	0.890173	2.18982558	Candidatus Electronema aureum	2005002	Bacteria	Bacteria	331	2.55e-86	NTclustered	gi\|2322424202\|emb\|OW818638.1\|	2005002	g90677	i0	91.02	0.995934959349594	245	22	99	0	2	246	1029569	1029813	Candidatus Electronema aureum isolate ENR-cMAG genome assembly, chromosome: 1	blastn	245	331	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electronema	Candidatus Electronema aureum
18127294	18127294	PRJNA1120203_P_NODE_93775_length_245_cov_0.895349_g92759_i0	PRJNA1120203	93775	245	0.895349	2.19360505	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	161	3.52e-35	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g92759	i0	80.374	0.873469387755102	214	40	87	2	33	245	2567285	2567073	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	214	161	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
20676697	20676697	PRJNA1120203_P_NODE_73697_length_260_cov_1.262032_g72681_i0	PRJNA1120203	73697	260	1.262032	3.2812832	Candidatus Electronema aureum	2005002	Bacteria	Bacteria	257	4.68e-64	NTclustered	gi\|2322424202\|emb\|OW818638.1\|	2005002	g72681	i0	85.375	0.973076923076923	253	31	96	6	11	260	944068	943819	Candidatus Electronema aureum isolate ENR-cMAG genome assembly, chromosome: 1	blastn	253	257	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electronema	Candidatus Electronema aureum
23227707	23227707	PRJNA1120203_P_NODE_81919_length_250_cov_0.870056_g80903_i0	PRJNA1120203	81919	250	0.870056	2.17514	Desulfovibrio piger	901	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g80903	i0	99.6	2.648	250	1	100	0	1	250	1062770	1062521	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	662	457	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
24500455	24500455	PRJNA1120203_P_NODE_102740_length_242_cov_0.911243_g101724_i0	PRJNA1120203	102740	242	0.911243	2.20520806	Geobacter sp. FeAm09	2597769	Bacteria	Bacteria	265	2.5699999999999997e-66	NTclustered	gi\|1735471693\|gb\|CP042466.1\|	2597769	g101724	i0	86.667	0.991735537190083	240	31	99	1	1	240	845499	845261	Geobacter sp. FeAm09 chromosome, complete genome	blastn	240	265	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp. FeAm09
24501444	24501444	PRJNA1120203_P_NODE_89200_length_247_cov_0.885057_g88184_i0	PRJNA1120203	89200	247	0.885057	2.18609079	Desulfovibrio piger	901	Bacteria	Bacteria	318	1.9899999999999998e-82	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g88184	i0	95.05	1.81781376518219	202	10	82	0	46	247	2222626	2222425	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	449	318	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
24501555	24501555	PRJNA1120203_P_NODE_96260_length_244_cov_0.900585_g95244_i0	PRJNA1120203	96260	244	0.900585	2.1974274	Desulfovibrio piger	901	Bacteria	Bacteria	412	8.759999999999998e-111	NTclustered	gi\|1102127722\|emb\|LT630450.1\|	901	g95244	i0	97.143	4.75819672131148	245	5	100	2	1	244	1826706	1826463	Desulfovibrio piger isolate FI11049 genome assembly, chromosome: I	blastn	1161	412	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger

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