metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA603943" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA603943" 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
577996	577996	PRJNA603943_P_NODE_67281_length_243_cov_0.905882_g67089_i0	PRJNA603943	67281	243	0.905882	2.20129326	Desulfovibrio piger	901	Bacteria	Bacteria	411	3.14e-110	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g67089	i0	97.119	1.98353909465021	243	7	100	0	1	243	1818676	1818434	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	482	411	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
3128843	3128843	PRJNA603943_P_NODE_62803_length_245_cov_0.895349_g62611_i0	PRJNA603943	62803	245	0.895349	2.19360505	Desulfovibrio piger	901	Bacteria	Bacteria	442	1.1199999999999994e-119	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g62611	i0	99.184	92.6040816326531	245	2	100	0	1	245	1434565	1434809	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	22688	442	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
6247001	6247001	PRJNA603943_P_NODE_70325_length_241_cov_0.916667_g70133_i0	PRJNA603943	70325	241	0.916667	2.20916747	Pseudomonadati	3379134	Bacteria	Bacteria	86.1	2.14e-12	NTclustered	gi\|2621701248\|emb\|OY759968.1\|	57664	g70133	i0	76.757	4.02489626556017	185	23	71	15	33	204	46696	46873	MAG: Desulfuromonas thiophila isolate 5d13b52e-9f0b-4035-9b75-2cca1ad4870f genome assembly, chromosome: 1	blastn	970	86.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas thiophila
6956140	6956140	PRJNA603943_P_NODE_59566_length_247_cov_0.885057_g59374_i0	PRJNA603943	59566	247	0.885057	2.18609079	Desulfovibrio piger	901	Bacteria	Bacteria	429	8.83e-116	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g59374	i0	97.976	1	247	5	100	0	1	247	1824489	1824735	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	247	429	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
8230883	8230883	PRJNA603943_P_NODE_54647_length_250_cov_0.870056_g54455_i0	PRJNA603943	54647	250	0.870056	2.17514	Desulfovibrio piger	901	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g54455	i0	100	28.892	250	0	100	0	1	250	1644782	1644533	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	7223	462	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
9506245	9506245	PRJNA603943_P_NODE_62068_length_246_cov_0.890173_g61876_i0	PRJNA603943	62068	246	0.890173	2.18982558	Desulfovibrio piger	901	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g61876	i0	99.187	2	246	2	100	0	1	246	541899	542144	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	492	444	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
9506418	9506418	PRJNA603943_P_NODE_67768_length_242_cov_0.911243_g67576_i0	PRJNA603943	67768	242	0.911243	2.20520806	Desulfovibrio piger	901	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g67576	i0	100	20.2933884297521	242	0	100	0	1	242	3020830	3021071	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	4911	448	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
10782141	10782141	PRJNA603943_P_NODE_62249_length_246_cov_0.890173_g62057_i0	PRJNA603943	62249	246	0.890173	2.18982558	Desulfovibrio piger	901	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g62057	i0	100	8.28455284552846	246	0	100	0	1	246	595054	595299	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	2038	455	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
12057208	12057208	PRJNA603943_P_NODE_66210_length_243_cov_0.905882_g66018_i0	PRJNA603943	66210	243	0.905882	2.20129326	Desulfovibrio piger	901	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g66018	i0	100	5.16049382716049	243	0	100	0	1	243	694372	694614	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	1254	449	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
13330978	13330978	PRJNA603943_P_NODE_30731_length_326_cov_1.209486_g30539_i0	PRJNA603943	30731	326	1.209486	3.94292436	Desulfovibrio piger	901	Bacteria	Bacteria	571	1.9e-158	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g30539	i0	98.466	1	326	1	100	2	1	326	1156557	1156878	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	326	571	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
13331754	13331754	PRJNA603943_P_NODE_56371_length_249_cov_0.875000_g56179_i0	PRJNA603943	56371	249	0.875	2.17875	Desulfovibrio piger	901	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g56179	i0	99.598	2.98393574297189	249	1	100	0	1	249	605408	605160	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	743	455	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
13332049	13332049	PRJNA603943_P_NODE_66651_length_243_cov_0.905882_g66459_i0	PRJNA603943	66651	243	0.905882	2.20129326	Desulfovibrio piger	901	Bacteria	Bacteria	418	1.8699999999999998e-112	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g66459	i0	97.925	2.36213991769547	241	5	99	0	3	243	2412812	2412572	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	574	418	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
17155694	17155694	PRJNA603943_P_NODE_65634_length_244_cov_0.900585_g65442_i0	PRJNA603943	65634	244	0.900585	2.1974274	Syntrophotalea acetylenica	29542	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1109565244\|gb\|CP015455.1\|	29542	g65442	i0	100	0.344262295081967	28	0	11	0	180	207	112	139	Syntrophotalea acetylenica strain DSM 3246 chromosome, complete genome	blastn	84	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Syntrophotaleaceae	Syntrophotalea	Syntrophotalea acetylenica
20269526	20269526	PRJNA603943_P_NODE_2536_length_893_cov_1.878049_g2384_i0	PRJNA603943	2536	893	1.878049	16.77097757	Bacteria	2	Bacteria	Bacteria	488	5.8e-133	NTclustered	gi\|470490011\|ref\|NR_076962.1\|	2358	g2384	i0	78.166	507.893617021277	829	137	90	33	11	815	1263	455	Desulfomonile tiedjei strain DCB-1 23S ribosomal RNA gene, complete sequence	blastn	453549	488	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfomonilia	Desulfomonilales	Desulfomonilaceae	Desulfomonile	Desulfomonile tiedjei
20980138	20980138	PRJNA603943_P_NODE_62057_length_246_cov_0.890173_g61865_i0	PRJNA603943	62057	246	0.890173	2.18982558	Desulfovibrio piger	901	Bacteria	Bacteria	422	1.47e-113	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g61865	i0	97.561	2.15040650406504	246	6	100	0	1	246	1900908	1900663	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	529	422	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
20980333	20980333	PRJNA603943_P_NODE_68697_length_242_cov_0.911243_g68505_i0	PRJNA603943	68697	242	0.911243	2.20520806	Desulfovibrio piger	901	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g68505	i0	100	2	242	0	100	0	1	242	1052112	1052353	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	484	448	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
23530521	23530521	PRJNA603943_P_NODE_67019_length_243_cov_0.905882_g66827_i0	PRJNA603943	67019	243	0.905882	2.20129326	Desulfovibrio piger	901	Bacteria	Bacteria	357	4.1399999999999997e-94	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g66827	i0	93.145	2.26337448559671	248	9	100	6	1	243	631178	631422	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	550	357	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
24803906	24803906	PRJNA603943_P_NODE_56740_length_249_cov_0.875000_g56548_i0	PRJNA603943	56740	249	0.875	2.17875	Desulfovibrio piger	901	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g56548	i0	99.598	1.98393574297189	249	1	100	0	1	249	2805784	2805536	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	494	455	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);;