metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1137393" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1137393" 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
4111811	4111811	PRJNA1137393_P_NODE_54164_length_166_cov_0.888889_g53648_i0	PRJNA1137393	54164	166	0.888889	1.47555574	Desulfosediminicola flagellatus	2569541	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1861338670\|gb\|CP050698.1\|	2569541	g53648	i0	100	0.849397590361446	29	0	17	0	26	54	3781549	3781521	Desulfosediminicola flagellatus strain IMCC35005 chromosome, complete genome	blastn	141	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfosediminicola	Desulfosediminicola flagellatus
5388037	5388037	PRJNA1137393_P_NODE_67945_length_163_cov_0.912281_g67429_i0	PRJNA1137393	67945	163	0.912281	1.48701803	Geobacter metallireducens	28232	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|78192483\|gb\|CP000148.1\|	269799	g67429	i0	92.308	1.07361963190184	39	3	24	0	72	110	2445666	2445704	Geobacter metallireducens GS-15, complete genome	blastn	175	56.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter metallireducens
7409969	7409969	PRJNA1137393_P_NODE_21866_length_196_cov_7.741497_g21350_i0	PRJNA1137393	21866	196	7.741497	15.17333412	Desulfurivibrio	427922	Bacteria	Bacteria	178	2.68e-40	NTclustered	gi\|470485970\|ref\|NR_076727.1\|	427923	g21350	i0	84.53	110.326530612245	181	27	92	1	17	196	936	1116	Desulfurivibrio alkaliphilus strain AHT 2 23S ribosomal RNA gene, complete sequence	blastn	21624	178	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfurivibrio	Desulfurivibrio alkaliphilus
7409987	7409987	PRJNA1137393_P_NODE_29366_length_182_cov_2.270677_g28850_i0	PRJNA1137393	29366	182	2.270677	4.13263214	Geotalea	2910589	Bacteria	Bacteria	195	2.43e-45	NTclustered	gi\|470481994\|ref\|NR_076507.1\|	351604	g28850	i0	86.339	195.851648351648	183	20	99	5	2	181	532	352	Geobacter uraniireducens strain Rf4 23S ribosomal RNA gene, complete sequence	blastn	35645	195	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geotalea	Geotalea uraniireducens
13038383	13038383	PRJNA1137393_P_NODE_16851_length_213_cov_2.695122_g16335_i0	PRJNA1137393	16851	213	2.695122	5.74060986	Desulfosarcina widdelii	947919	Bacteria	Bacteria	207	3.78e-49	NTclustered	gi\|1773416083\|dbj\|AP021875.1\|	947919	g16335	i0	89.157	485.413145539906	166	18	78	0	6	171	6916668	6916503	Desulfosarcina widdelii PP31 DNA, complete genome	blastn	103393	207	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	Desulfosarcina widdelii
13038536	13038536	PRJNA1137393_P_NODE_63991_length_164_cov_0.904348_g63475_i0	PRJNA1137393	63991	164	0.904348	1.48313072	Nitratidesulfovibrio liaohensis	2604158	Bacteria	Bacteria	287	3.45e-73	NTclustered	gi\|2575677524\|gb\|CP133659.1\|	2604158	g63475	i0	98.171	1	164	3	100	0	1	164	2419513	2419350	Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome	blastn	164	287	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio liaohensis
15059723	15059723	PRJNA1137393_P_NODE_21912_length_196_cov_2.190476_g21396_i0	PRJNA1137393	21912	196	2.190476	4.29333296	Pseudomonadati	3379134	Bacteria	Bacteria	233	5.639999999999999e-57	NTclustered	gi\|2425841343\|dbj\|AP027151.1\|	351604	g21396	i0	88.947	279.295918367347	190	19	96	2	7	195	753578	753390	Geotalea uraniireducens NIT-SL11 DNA, complete genome	blastn	54742	235	0.991489361702128	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geotalea	Geotalea uraniireducens
15587576	15587576	PRJNA1137393_P_NODE_22433_length_195_cov_1.287671_g21917_i0	PRJNA1137393	22433	195	1.287671	2.51095845	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	135	1.6300000000000002e-27	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g21917	i0	80.791	93.8461538461538	177	31	90	3	1	176	1711875	1711701	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	18300	135	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
18883580	18883580	PRJNA1137393_P_NODE_10615_length_255_cov_1.009709_g10099_i0	PRJNA1137393	10615	255	1.009709	2.57475795	Bacteria	2	Bacteria	Bacteria	272	1.6299999999999998e-68	NTclustered	gi\|2518551120\|emb\|OX638332.1\|	2080303	g10099	i0	86.667	117.564705882353	255	22	100	3	1	255	22571	22813	MAG: Candidatus Dadabacteria bacterium isolate 28c7ac20-cd97-4a81-9be0-f5b43b5a8d2b genome assembly, chromosome: 1	blastn	29979	272	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
23984355	23984355	PRJNA1137393_P_NODE_18139_length_209_cov_0.893750_g17623_i0	PRJNA1137393	18139	209	0.89375	1.8679375	Geobacteraceae	213422	Bacteria	Bacteria	364	2.0699999999999992e-96	NTclustered	gi\|1976315905\|dbj\|AP024469.1\|	2495594	g17623	i0	98.544	527.53110047846906	206	3	99	0	4	209	736748	736543	Geobacter sp. SVR DNA, complete genome	blastn	110254	366	0.994535519125683	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp. SVR

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