metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1095825" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1095825" 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
2751065	2751065	PRJNA1095825_P_NODE_206203_length_272_cov_1.452261_g203140_i0	PRJNA1095825	206203	272	1.452261	3.95014992	Desulfosarcina ovata	83564	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|1774945160\|dbj\|AP021876.1\|	885957	g203140	i0	100	0.102941176470588	28	0	10	0	210	237	7068783	7068756	Desulfosarcina ovata subsp. sediminis 28bB2T DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	Desulfosarcina ovata
2751707	2751707	PRJNA1095825_P_NODE_275443_length_244_cov_1.438596_g272380_i0	PRJNA1095825	275443	244	1.438596	3.51017424	Trichlorobacter ammonificans	2916410	Bacteria	Bacteria	202	2.07e-47	NTclustered	gi\|2542251251\|emb\|OW150024.1\|	2916410	g272380	i0	82.128	49.2254098360656	235	42	96	0	10	244	2586895	2586661	Trichlorobacter sp. G1 genome assembly, chromosome: GEAMG1	blastn	12011	202	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Trichlorobacter	Trichlorobacter ammonificans
4027273	4027273	PRJNA1095825_P_NODE_236924_length_251_cov_0.865169_g233861_i0	PRJNA1095825	236924	251	0.865169	2.17157419	Maridesulfovibrio salexigens	880	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|242120376\|gb\|CP001649.1\|	526222	g233861	i0	100	0.231075697211155	30	0	12	0	211	240	2476254	2476283	Desulfovibrio salexigens DSM 2638, complete genome	blastn	58	56.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Maridesulfovibrio	Maridesulfovibrio salexigens
4027845	4027845	PRJNA1095825_P_NODE_292804_length_241_cov_1.404762_g289741_i0	PRJNA1095825	292804	241	1.404762	3.38547642	uncultured Desulfobulbus sp.	239745	Bacteria	Bacteria	167	7.429999999999999e-37	NTclustered	gi\|2621704320\|emb\|OY760916.1\|	239745	g289741	i0	80.357	0.929460580912863	224	41	92	3	1	222	2882804	2883026	MAG: uncultured Desulfobulbus sp. isolate 7a05128d-adad-4d17-beb6-ff3d102eb21b genome assembly, chromosome: 1	blastn	224	167	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	uncultured Desulfobulbus sp.
7853804	7853804	PRJNA1095825_P_NODE_286927_length_242_cov_1.402367_g283864_i0	PRJNA1095825	286927	242	1.402367	3.39372814	Geobacter pickeringii	345632	Bacteria	Bacteria	156	1.6200000000000002e-33	NTclustered	gi\|747129828\|gb\|CP009788.1\|	345632	g283864	i0	78.788	11.3636363636364	231	49	95	0	12	242	929307	929077	Geobacter pickeringii strain G13, complete genome	blastn	2750	156	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter pickeringii
9128778	9128778	PRJNA1095825_P_NODE_283528_length_243_cov_0.905882_g280465_i0	PRJNA1095825	283528	243	0.905882	2.20129326	Geobacter sulfurreducens	35554	Bacteria	Bacteria	261	3.34e-65	NTclustered	gi\|2499315885\|dbj\|AP028061.1\|	1260928	g280465	i0	86.25	1.98765432098765	240	33	99	0	4	243	555691	555452	Geobacter sulfurreducens subsp. ethanolicus OSK2A DNA, complete genome	blastn	483	261	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
11679798	11679798	PRJNA1095825_P_NODE_289370_length_242_cov_0.911243_g286307_i0	PRJNA1095825	289370	242	0.911243	2.20520806	Pelobacter propionicus	29543	Bacteria	Bacteria	189	1.5899999999999996e-43	NTclustered	gi\|118501159\|gb\|CP000482.1\|	338966	g286307	i0	81.974	0.962809917355372	233	32	94	6	4	231	3403892	3404119	Pelobacter propionicus DSM 2379, complete genome	blastn	233	189	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Pelobacter	Pelobacter propionicus
12954773	12954773	PRJNA1095825_P_NODE_273031_length_245_cov_0.895349_g269968_i0	PRJNA1095825	273031	245	0.895349	2.19360505	Syntrophus aciditrophicus	316277	Bacteria	Bacteria	398	2.47e-106	NTclustered	gi\|85720936\|gb\|CP000252.1\|	56780	g269968	i0	95.918	1	245	10	100	0	1	245	2867645	2867889	Syntrophus aciditrophicus SB, complete genome	blastn	245	398	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae	Syntrophus	Syntrophus aciditrophicus
12954929	12954929	PRJNA1095825_P_NODE_289871_length_242_cov_0.911243_g286808_i0	PRJNA1095825	289871	242	0.911243	2.20520806	Desulfuromonas versatilis	2802975	Bacteria	Bacteria	159	1.2499999999999999e-34	NTclustered	gi\|2065532709\|dbj\|AP024355.1\|	2802975	g286808	i0	82.682	36.504132231405	179	31	74	0	38	216	1160203	1160381	Desulfuromonas versatilis NIT-T3 DNA, complete genome	blastn	8834	159	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas versatilis
14229607	14229607	PRJNA1095825_P_NODE_262592_length_247_cov_0.885057_g259529_i0	PRJNA1095825	262592	247	0.885057	2.18609079	Geomonas oryzisoli	2847992	Bacteria	Bacteria	302	2.01e-77	NTclustered	gi\|2056214585\|gb\|CP076723.1\|	2847992	g259529	i0	88.664	97.4939271255061	247	28	100	0	1	247	133168	132922	Geomonas oryzisoli strain RG10 chromosome, complete genome	blastn	24081	302	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas oryzisoli
14229657	14229657	PRJNA1095825_P_NODE_267852_length_246_cov_0.890173_g264789_i0	PRJNA1095825	267852	246	0.890173	2.18982558	Geobacter benzoatilyticus	2815309	Bacteria	Bacteria	355	1.51e-93	NTclustered	gi\|2004017374\|gb\|CP071382.1\|	2815309	g264789	i0	92.683	1	246	18	100	0	1	246	2812126	2811881	Geobacter benzoatilyticus strain Jerry-YX chromosome, complete genome	blastn	246	355	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter benzoatilyticus
14229945	14229945	PRJNA1095825_P_NODE_295632_length_241_cov_0.916667_g292569_i0	PRJNA1095825	295632	241	0.916667	2.20916747	Desulfuromonas versatilis	2802975	Bacteria	Bacteria	261	3.31e-65	NTclustered	gi\|2065532709\|dbj\|AP024355.1\|	2802975	g292569	i0	86.498	5.24896265560166	237	32	98	0	5	241	304941	304705	Desulfuromonas versatilis NIT-T3 DNA, complete genome	blastn	1265	261	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas versatilis
15503145	15503145	PRJNA1095825_P_NODE_219793_length_262_cov_1.629630_g216730_i0	PRJNA1095825	219793	262	1.62963	4.2696306	Desulfatiglandales bacterium	3024416	Bacteria	Bacteria	171	6.33e-38	NTclustered	gi\|2621702716\|emb\|OY759599.1\|	3024416	g216730	i0	79.032	1.89312977099237	248	52	95	0	11	258	7961504	7961257	MAG: Desulfatiglandales bacterium isolate ef928343-fb2c-4ac1-bd77-a4af7a033044 genome assembly, chromosome: 1	blastn	496	171	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfatiglandales			Desulfatiglandales bacterium
16778062	16778062	PRJNA1095825_P_NODE_270834_length_245_cov_0.895349_g267771_i0	PRJNA1095825	270834	245	0.895349	2.19360505	Desulfobulbus propionicus	894	Bacteria	Bacteria	228	3.4199999999999995e-55	NTclustered	gi\|320120648\|gb\|CP002364.1\|	577650	g267771	i0	86.473	0.844897959183673	207	28	84	0	39	245	1887388	1887182	Desulfobulbus propionicus DSM 2032, complete genome	blastn	207	228	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus propionicus
24426700	24426700	PRJNA1095825_P_NODE_252980_length_248_cov_1.285714_g249917_i0	PRJNA1095825	252980	248	1.285714	3.18857072	Desulfuromonas soudanensis	1603606	Bacteria	Bacteria	213	9.72e-51	NTclustered	gi\|924528553\|gb\|CP010802.1\|	1603606	g249917	i0	83.478	0.92741935483871	230	36	92	2	20	248	1403823	1404051	Desulfuromonas soudanensis strain WTL chromosome, complete genome	blastn	230	213	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas soudanensis

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