metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1002570" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1002570" 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
10355367	10355367	PRJNA1002570_P_NODE_19449_length_292_cov_1.835616_g19254_i0	PRJNA1002570	19449	292	1.835616	5.35999872	Geomonas paludis	2740185	Bacteria	Bacteria	193	1.53e-44	NTclustered	gi\|2233265061\|gb\|CP096574.1\|	2740185	g19254	i0	90.972	66.2842465753425	144	11	49	2	2	144	1776943	1777085	Geomonas paludis strain RG22 chromosome, complete genome	blastn	19355	193	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas paludis
11630682	11630682	PRJNA1002570_P_NODE_13550_length_326_cov_3.320158_g13355_i0	PRJNA1002570	13550	326	3.320158	10.82371508	Desulfuromonas thiophila	57664	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2621701248\|emb\|OY759968.1\|	57664	g13355	i0	100	0.0889570552147239	29	0	9	0	23	51	1636585	1636557	MAG: Desulfuromonas thiophila isolate 5d13b52e-9f0b-4035-9b75-2cca1ad4870f genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas thiophila
11630707	11630707	PRJNA1002570_P_NODE_15110_length_310_cov_5.691983_g14915_i0	PRJNA1002570	15110	310	5.691983	17.6451473	Nitratidesulfovibrio liaohensis	2604158	Bacteria	Bacteria	132	3.62e-26	NTclustered	gi\|2575677524\|gb\|CP133659.1\|	2604158	g14915	i0	82.781	2.63548387096774	151	22	48	3	1	149	1333550	1333698	Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome	blastn	817	132	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio liaohensis
11631218	11631218	PRJNA1002570_P_NODE_45970_length_214_cov_4.028369_g45775_i0	PRJNA1002570	45970	214	4.028369	8.62070966	Desulfolithobacter dissulfuricans	2795293	Bacteria	Bacteria	152	1.8099999999999998e-32	NTclustered	gi\|2304357171\|dbj\|AP024233.1\|	2795293	g45775	i0	81.383	14.7570093457944	188	33	87	2	14	200	219320	219134	Desulfobulbaceae bacterium GF1 GF1 DNA, complete genome	blastn	3158	152	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfolithobacter	Desulfolithobacter dissulfuricans
12479586	12479586	PRJNA1002570_P_NODE_36330_length_251_cov_0.865169_g36135_i0	PRJNA1002570	36330	251	0.865169	2.17157419	Pseudomonadati	3379134	Bacteria	Bacteria	67.6	8.12e-7	NTclustered	gi\|1566432249\|gb\|CP026538.1\|	296842	g36135	i0	91.667	0.462151394422311	48	4	19	0	17	64	2081409	2081456	Solidesulfovibrio carbinolicus strain DSM 3852 chromosome, complete genome	blastn	116	67.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Solidesulfovibrio	Solidesulfovibrio carbinolicus
15454795	15454795	PRJNA1002570_P_NODE_15973_length_310_cov_2.729958_g15778_i0	PRJNA1002570	15973	310	2.729958	8.4628698	Desulfurivibrio alkaliphilus	427923	Bacteria	Bacteria	97.1	1.32e-15	NTclustered	gi\|296923907\|gb\|CP001940.1\|	589865	g15778	i0	87.952	0.690322580645161	83	9	27	1	200	282	2159372	2159453	Desulfurivibrio alkaliphilus AHT2, complete genome	blastn	214	97.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfurivibrio	Desulfurivibrio alkaliphilus
16303078	16303078	PRJNA1002570_P_NODE_13193_length_330_cov_3.583658_g12998_i0	PRJNA1002570	13193	330	3.583658	11.8260714	Bacteria	2	Bacteria	Bacteria	121	8.4e-23	NTclustered	gi\|78192483\|gb\|CP000148.1\|	269799	g12998	i0	83.206	16.830303030303	131	22	40	0	161	291	3840274	3840404	Geobacter metallireducens GS-15, complete genome	blastn	5554	121	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter metallireducens
20553303	20553303	PRJNA1002570_P_NODE_15557_length_310_cov_3.156118_g15362_i0	PRJNA1002570	15557	310	3.156118	9.7839658	Syntrophotalea acetylenica	29542	Bacteria	Bacteria	87.9	7.94e-13	NTclustered	gi\|1109565244\|gb\|CP015455.1\|	29542	g15362	i0	89.855	1.9741935483871	69	5	22	2	4	71	308609	308542	Syntrophotalea acetylenica strain DSM 3246 chromosome, complete genome	blastn	612	87.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Syntrophotaleaceae	Syntrophotalea	Syntrophotalea acetylenica
21828988	21828988	PRJNA1002570_P_NODE_19138_length_293_cov_2.886364_g18943_i0	PRJNA1002570	19138	293	2.886364	8.45704652	Pelobacter propionicus	29543	Bacteria	Bacteria	97.1	1.24e-15	NTclustered	gi\|118501159\|gb\|CP000482.1\|	338966	g18943	i0	79.021	0.976109215017065	143	28	48	2	151	292	3419459	3419600	Pelobacter propionicus DSM 2379, complete genome	blastn	286	97.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Pelobacter	Pelobacter propionicus

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