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

17 rows where analysis = "blastn", bioproject = "PRJEB66218" 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
133081	133081	PRJEB66218_P_NODE_28761_length_690_cov_4.352941_g26472_i0	PRJEB66218	28761	690	4.352941	30.0352929	Desulfatiglandales bacterium	3024416	Bacteria	Bacteria	122	5.169999999999999e-23	NTclustered	gi\|2621702716\|emb\|OY759599.1\|	3024416	g26472	i0	89.583	1.64202898550725	96	10	14	0	555	650	6280006	6279911	MAG: Desulfatiglandales bacterium isolate ef928343-fb2c-4ac1-bd77-a4af7a033044 genome assembly, chromosome: 1	blastn	1133	122	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfatiglandales			Desulfatiglandales bacterium
134103	134103	PRJEB66218_P_NODE_67821_length_392_cov_2.903323_g65397_i0	PRJEB66218	67821	392	2.903323	11.38102616	Geobacter metallireducens	28232	Bacteria	Bacteria	167	1.28e-36	NTclustered	gi\|78192483\|gb\|CP000148.1\|	269799	g65397	i0	81.683	4.37244897959184	202	35	51	2	2	202	381436	381636	Geobacter metallireducens GS-15, complete genome	blastn	1714	167	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter metallireducens
1407418	1407418	PRJEB66218_P_NODE_245202_length_195_cov_2.611940_g242771_i0	PRJEB66218	245202	195	2.61194	5.093283	Desulfuromonas sp. AOP6	1566351	Bacteria	Bacteria	121	4.549999999999999e-23	NTclustered	gi\|1847250123\|dbj\|AP022810.1\|	1566351	g242771	i0	78.125	0.984615384615385	192	40	98	2	2	192	466656	466846	Desulfuromonas sp. AOP6 DNA, complete genome	blastn	192	121	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas sp. AOP6
3958579	3958579	PRJEB66218_P_NODE_217684_length_207_cov_0.890411_g215254_i0	PRJEB66218	217684	207	0.890411	1.84315077	Desulfuromonas thiophila	57664	Bacteria	Bacteria	122	1.36e-23	NTclustered	gi\|2621701248\|emb\|OY759968.1\|	57664	g215254	i0	88.462	8.0048309178744	104	8	49	4	57	158	589273	589374	MAG: Desulfuromonas thiophila isolate 5d13b52e-9f0b-4035-9b75-2cca1ad4870f genome assembly, chromosome: 1	blastn	1657	122	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas thiophila
3958735	3958735	PRJEB66218_P_NODE_227284_length_205_cov_0.902778_g224854_i0	PRJEB66218	227284	205	0.902778	1.8506949	Desulfonema magnum	45655	Bacteria	Bacteria	150	6.17e-32	NTclustered	gi\|2007135636\|gb\|CP061800.1\|	45655	g224854	i0	80.788	112.668292682927	203	30	97	9	7	205	7420339	7420142	Desulfonema magnum strain 4be13 chromosome, complete genome	blastn	23097	150	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfonema	Desulfonema magnum
5234078	5234078	PRJEB66218_P_NODE_158185_length_235_cov_2.632184_g155755_i0	PRJEB66218	158185	235	2.632184	6.1856324	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	180	9.26e-41	NTclustered	gi\|2556892445\|gb\|CP129479.1\|	2202153	g155755	i0	81.25	137.455319148936	240	30	99	10	3	235	886786	886555	MAG: Thermodesulfobacteriota bacterium isolate cMAG.17 chromosome, complete genome	blastn	32302	180	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
7371538	7371538	PRJEB66218_P_NODE_109926_length_289_cov_3.026316_g107497_i0	PRJEB66218	109926	289	3.026316	8.74605324	Nitratidesulfovibrio	2802295	Bacteria	Bacteria	226	1.49e-54	NTclustered	gi\|2431395895\|gb\|CP116246.1\|	881	g107497	i0	81.295	84.8477508650519	278	52	96	0	5	282	1651720	1651443	Nitratidesulfovibrio vulgaris strain L2 chromosome, complete genome	blastn	24521	226	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio vulgaris
9061763	9061763	PRJEB66218_P_NODE_85528_length_338_cov_2.346570_g83101_i0	PRJEB66218	85528	338	2.34657	7.9314066	Salidesulfovibrio onnuriiensis	2583823	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|1725298512\|gb\|CP040751.1\|	2583823	g83101	i0	100	0.0828402366863905	28	0	8	0	233	260	1574387	1574414	Salidesulfovibrio onnuriiensis strain IOR2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Salidesulfovibrio	Salidesulfovibrio onnuriiensis
10336656	10336656	PRJEB66218_P_NODE_49949_length_479_cov_5.349282_g47532_i0	PRJEB66218	49949	479	5.349282	25.62306078	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	486	1.0799999999999998e-132	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g47532	i0	85.031	134.70981210856	481	69	100	3	1	479	1713583	1713104	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	64526	486	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
12888193	12888193	PRJEB66218_P_NODE_88491_length_331_cov_1.740741_g86064_i0	PRJEB66218	88491	331	1.740741	5.76185271	Desulfoferula mesophila	3058419	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|2619692108\|dbj\|AP028679.1\|	3058419	g86064	i0	100	0.0845921450151057	28	0	8	0	111	138	2343678	2343651	Desulfoferula mesophila 12FAK DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae	Desulfoferula	Desulfoferula mesophila
13748312	13748312	PRJEB66218_P_NODE_44331_length_518_cov_3.319475_g41920_i0	PRJEB66218	44331	518	3.319475	17.1948805	Pseudomonadati	3379134	Bacteria	Bacteria	571	3.1499999999999993e-158	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g41920	i0	88.223	148.455598455598	484	50	93	7	1	480	1712498	1712978	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	76900	571	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
14160895	14160895	PRJEB66218_P_NODE_217512_length_207_cov_0.890411_g215082_i0	PRJEB66218	217512	207	0.890411	1.84315077	Syntrophales bacterium	2928017	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2621706256\|emb\|OY764159.1\|	2928017	g215082	i0	100	0.144927536231884	30	0	14	0	4	33	4524880	4524851	MAG: Syntrophales bacterium isolate 28fc5764-0b9a-428c-a12f-8ca866e14e1d genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales bacterium
14161308	14161308	PRJEB66218_P_NODE_245632_length_194_cov_2.887218_g243200_i0	PRJEB66218	245632	194	2.887218	5.60120292	uncultured Desulfuromonas sp.	181013	Bacteria	Bacteria	163	7.41e-36	NTclustered	gi\|2621785003\|emb\|OY781461.1\|	181013	g243200	i0	85.987	162.634020618557	157	17	80	4	5	160	4972	5124	MAG: uncultured Desulfuromonas sp. isolate fc3ca4bd-ee85-4ad2-8383-0bc2b366ff34 genome assembly, chromosome: 1	blastn	31551	163	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	uncultured Desulfuromonas sp.
15432809	15432809	PRJEB66218_P_NODE_103533_length_300_cov_1.631799_g101105_i0	PRJEB66218	103533	300	1.631799	4.895397	Solidesulfovibrio magneticus	184917	Bacteria	Bacteria	152	2.67e-32	NTclustered	gi\|239794502\|dbj\|AP010904.1\|	573370	g101105	i0	76.206	14.44	311	60	100	11	1	300	2702717	2702410	Desulfovibrio magneticus RS-1 DNA, complete genome	blastn	4332	152	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Solidesulfovibrio	Solidesulfovibrio magneticus
15433403	15433403	PRJEB66218_P_NODE_130013_length_262_cov_1.293532_g127584_i0	PRJEB66218	130013	262	1.293532	3.38905384	Desulfarculia bacterium	3065862	Bacteria	Bacteria	130	1.07e-25	NTclustered	gi\|2621702698\|emb\|OY759590.1\|	3065862	g127584	i0	85.156	7.19083969465649	128	17	48	2	136	262	335917	336043	MAG: Desulfarculia bacterium isolate 49400898-fc5b-42b7-bef8-a303f8702bb8 genome assembly, chromosome: 1	blastn	1884	130	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia				Desulfarculia bacterium
20121582	20121582	PRJEB66218_P_NODE_70076_length_384_cov_2.498452_g67652_i0	PRJEB66218	70076	384	2.498452	9.59405568	Pseudomonadati	3379134	Bacteria	Bacteria	468	3.07e-127	NTclustered	gi\|2891482193\|emb\|OZ219926.1\|	2202153	g67652	i0	88.66	151.408854166667	388	39	100	5	1	384	775482	775868	MAG: Thermodesulfobacteriota bacterium isolate 21442c6b-cc68-4f82-8039-a5361455a999 genome assembly, chromosome: 3	blastn	58141	468	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
21810755	21810755	PRJEB66218_P_NODE_64738_length_404_cov_30.233236_g62315_i0	PRJEB66218	64738	404	30.233236	122.14227344	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	108	8.15e-19	NTclustered	gi\|2556892445\|gb\|CP129479.1\|	2202153	g62315	i0	82.09	10.6287128712871	134	17	33	5	128	259	437321	437449	MAG: Thermodesulfobacteriota bacterium isolate cMAG.17 chromosome, complete genome	blastn	4294	108	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium

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