metadata: contig_metadata: 8 rows where bioproject = "PRJNA700095", tax_kingdom = "Pseudomonadati" and tax

8 rows where bioproject = "PRJNA700095", 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
683302	683302	PRJNA700095_P_NODE_54561_length_248_cov_1.748571_g53297_i0	PRJNA700095	54561	248	1.748571	4.33645608	Desulfuromonas soudanensis	1603606	Bacteria	Bacteria	176	1.28e-39	NTclustered	gi\|924528553\|gb\|CP010802.1\|	1603606	g53297	i0	79.918	52.7177419354839	244	46	98	3	5	246	2963917	2963675	Desulfuromonas soudanensis strain WTL chromosome, complete genome	blastn	13074	176	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas soudanensis
14712140	14712140	PRJNA700095_P_NODE_25472_length_340_cov_2.423221_g24208_i0	PRJNA700095	25472	340	2.423221	8.2389514	Pseudodesulfovibrio profundus	57320	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|1248817418\|emb\|LT907975.1\|	57320	g24208	i0	96.875	0.0941176470588235	32	0	9	1	115	146	14005	13975	Desulfovibrio profundus strain 500-1 genome assembly, chromosome: DPRO	blastn	32	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio profundus
27903777	27903777	PRJNA700095_P_NODE_50465_length_252_cov_1.720670_g49201_i0	PRJNA700095	50465	252	1.72067	4.3360884	Desulfobulbaceae bacterium DB1	1920419	Bacteria	Bacteria	58.5	1.12e-7	NR	OKY75304.1	1920419	g49201	i0	35.8	4.77380952380952	67	43	79.8	0	208	8	601	667	OKY75304.1 MAG: ATPase [Desulfobulbaceae bacterium DB1]	diamond	1203	58.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium DB1
28293962	28293962	PRJNA700095_P_NODE_35686_length_287_cov_1.439252_g34422_i0	PRJNA700095	35686	287	1.439252	4.13065324	Pseudomonadati	3379134	Bacteria	Bacteria	73.6	8.29e-13	NR	WP_214184548.1	40983	g34422	i0	37.9	3.0418118466899	95	58	98.3	1	1	282	131	225	WP_214184548.1 RCC1 domain-containing protein [Geobacter hydrogenophilus]	diamond	873	73.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter hydrogenophilus
29135631	29135631	PRJNA700095_P_NODE_62549_length_243_cov_0.905882_g61285_i0	PRJNA700095	62549	243	0.905882	2.20129326	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	45.1	5.69e-4	NR	MCK5310875.1	2049433	g61285	i0	42.4	0.728395061728395	59	31	72.8	1	39	215	4	59	MCK5310875.1 hypothetical protein [Desulfobacteraceae bacterium]	diamond	177	45.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
31484638	31484638	PRJNA700095_P_NODE_9876_length_620_cov_2.411335_g8649_i0	PRJNA700095	9876	620	2.411335	14.950277	Pseudomonadati	3379134	Bacteria	Bacteria	188	3.91e-53	NR	WP_020589162.1	2290	g8649	i0	47.1	10.0209677419355	208	108	99.7	2	618	1	323	530	WP_020589162.1 NADP-dependent glyceraldehyde-3-phosphate dehydrogenase [Desulfobacter curvatus]	diamond	6213	188	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacter	Desulfobacter curvatus
31990457	31990457	PRJNA700095_P_NODE_32578_length_299_cov_1.358407_g31314_i0	PRJNA700095	32578	299	1.358407	4.06163693	Pseudomonadati	3379134	Bacteria	Bacteria	129	2.97e-32	NR	WP_214296322.1	44671	g31314	i0	76.8	8.92976588628763	69	16	69.2	0	2	208	580	648	WP_214296322.1 asparagine synthase (glutamine-hydrolyzing) [Pelotalea chapellei]	diamond	2670	130	0.992307692307692	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Pelotalea	Pelotalea chapellei
32863805	32863805	PRJNA700095_P_NODE_19220_length_405_cov_2.415663_g17957_i0	PRJNA700095	19220	405	2.415663	9.78343515	Mailhella massiliensis	1903261	Bacteria	Bacteria	69.3	1.62e-12	NR	WP_077071860.1	1903261	g17957	i0	39.3	3.32592592592593	84	50	62.2	1	63	314	2	84	WP_077071860.1 RNA recognition motif domain-containing protein [Mailhella massiliensis]	diamond	1347	69.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Mailhella	Mailhella massiliensis

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