metadata: contig_metadata: 12 rows where bioproject = "PRJNA942359", tax_kingdom = "Pseudomonadati" and tax

12 rows where bioproject = "PRJNA942359", tax_kingdom = "Pseudomonadati" 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
1258769	1258769	PRJNA942359_P_NODE_17541_length_246_cov_0.901734_g17426_i0	PRJNA942359	17541	246	0.901734	2.21826564	Desulfomicrobium	898	Bacteria	Bacteria	405	1.48e-108	NTclustered	gi\|470484403\|ref\|NR_076646.1\|	899	g17426	i0	96.341	120.390243902439	246	9	100	0	1	246	1419	1664	Desulfomicrobium baculatum strain INMI strain X 23S ribosomal RNA gene, complete sequence	blastn	29616	405	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium baculatum
2198238	2198238	PRJNA942359_P_NODE_14762_length_250_cov_0.881356_g14647_i0	PRJNA942359	14762	250	0.881356	2.20339	Thiovibrio sp. Mzg5	2715680	Bacteria	Bacteria	296	9.47e-76	NTclustered	gi\|2883226761\|dbj\|AP022872.1\|	2715680	g14647	i0	90.308	0.908	227	20	91	2	8	234	309425	309649	Desulfobulbaceae bacterium Mzg5 DNA, complete genome	blastn	227	296	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Thiovibrionaceae	Thiovibrio	Thiovibrio sp. Mzg5
6026100	6026100	PRJNA942359_P_NODE_16085_length_248_cov_0.891429_g15970_i0	PRJNA942359	16085	248	0.891429	2.21074392	Thiovibrio sp. Mzg5	2715680	Bacteria	Bacteria	357	4.24e-94	NTclustered	gi\|2883226761\|dbj\|AP022872.1\|	2715680	g15970	i0	92.713	15.3346774193548	247	18	99	0	2	248	2637439	2637685	Desulfobulbaceae bacterium Mzg5 DNA, complete genome	blastn	3803	357	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Thiovibrionaceae	Thiovibrio	Thiovibrio sp. Mzg5
7301157	7301157	PRJNA942359_P_NODE_3586_length_422_cov_2.389685_g3471_i0	PRJNA942359	3586	422	2.389685	10.0844707	uncultured Mailhella sp.	1981031	Bacteria	Bacteria	647	0	NTclustered	gi\|2729058701\|emb\|OZ007001.1\|	1981031	g3471	i0	94.326	202.876777251185	423	23	100	1	1	422	1717830	1718252	MAG: uncultured Mailhella sp. isolate metabat2_pooled_hifiasm.920 MAG genome assembly, chromosome: 1	blastn	85614	647	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Mailhella	uncultured Mailhella sp.
20049515	20049515	PRJNA942359_P_NODE_13696_length_252_cov_0.871508_g13581_i0	PRJNA942359	13696	252	0.871508	2.19620016	Thiovibrio sp. Mzg5	2715680	Bacteria	Bacteria	322	1.58e-83	NTclustered	gi\|2883226761\|dbj\|AP022872.1\|	2715680	g13581	i0	89.723	1.21031746031746	253	24	100	2	1	252	680833	681084	Desulfobulbaceae bacterium Mzg5 DNA, complete genome	blastn	305	322	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Thiovibrionaceae	Thiovibrio	Thiovibrio sp. Mzg5
27783581	27783581	PRJNA942359_P_NODE_19524_length_243_cov_0.917647_g19409_i0	PRJNA942359	19524	243	0.917647	2.22988221	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	157	2.7899999999999998e-46	NR	MCU0604183.1	2044940	g19409	i0	96.3	1	81	3	100	0	1	243	121	201	MCU0604183.1 tripartite tricarboxylate transporter substrate-binding protein [Desulfobacterales bacterium]	diamond	243	157	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
29519912	29519912	PRJNA942359_P_NODE_19370_length_243_cov_0.917647_g19255_i0	PRJNA942359	19370	243	0.917647	2.22988221	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	121	7.96e-32	NR	MCU0592211.1	2044940	g19255	i0	100	0.802469135802469	65	0	80.2	0	241	47	210	274	MCU0592211.1 ABC transporter permease [Desulfobacterales bacterium]	diamond	195	121	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
30095137	30095137	PRJNA942359_P_NODE_13652_length_252_cov_0.871508_g13537_i0	PRJNA942359	13652	252	0.871508	2.19620016	Bacteria	2	Bacteria	Bacteria	132	2.12e-35	NR	HWP93370.1	2202153	g13537	i0	73.8	7.96428571428571	84	22	100	0	1	252	136	219	HWP93370.1 hypothetical protein [Thermodesulfobacteriota bacterium]	diamond	2007	132	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
30562111	30562111	PRJNA942359_P_NODE_19413_length_243_cov_0.917647_g19298_i0	PRJNA942359	19413	243	0.917647	2.22988221	Syntrophobacteraceae bacterium	2052185	Bacteria	Bacteria	90.5	5.7e-19	NR	HAA02553.1	2052185	g19298	i0	51.3	0.987654320987654	80	39	98.8	0	241	2	179	258	HAA02553.1 primosomal protein N' [Syntrophobacteraceae bacterium]	diamond	240	90.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae		Syntrophobacteraceae bacterium
31517532	31517532	PRJNA942359_P_NODE_16096_length_248_cov_0.891429_g15981_i0	PRJNA942359	16096	248	0.891429	2.21074392	Bacteria	2	Bacteria	Bacteria	87.4	1.11e-18	NR	HYS44187.1	2282154	g15981	i0	77.8	1.69354838709677	54	12	65.3	0	86	247	172	225	HYS44187.1 transposase family protein [Geobacteraceae bacterium]	diamond	420	88.2	0.99092970521542	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium
31637022	31637022	PRJNA942359_P_NODE_13776_length_252_cov_0.871508_g13661_i0	PRJNA942359	13776	252	0.871508	2.19620016	Candidatus Electrothrix gigas	2202844	Bacteria	Bacteria	95.1	6.02e-21	NR	MCI5134752.1	2202844	g13661	i0	57.8	0.988095238095238	83	35	98.8	0	1	249	286	368	MCI5134752.1 glycosyltransferase [Candidatus Electrothrix gigas]	diamond	249	95.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electrothrix	Candidatus Electrothrix gigas
32648792	32648792	PRJNA942359_P_NODE_17080_length_247_cov_0.896552_g16965_i0	PRJNA942359	17080	247	0.896552	2.21448344	Syntrophales bacterium	2928017	Bacteria	Bacteria	66.2	2.37e-11	NR	MCK9362623.1	2928017	g16965	i0	67.5	0.48582995951417	40	13	48.6	0	122	3	3	42	MCK9362623.1 hypothetical protein [Syntrophales bacterium]	diamond	120	66.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales 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);;