metadata: contig_metadata: 12 rows where bioproject = "PRJNA561212" and tax

12 rows where bioproject = "PRJNA561212" 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
6234263	6234263	PRJNA561212_P_NODE_16845_length_276_cov_1.458128_g16634_i0	PRJNA561212	16845	276	1.458128	4.02443328	root	1	Root_unresolved	Root_unresolved	279	1.07e-70	NTclustered	gi\|470477500\|ref\|NR_076387.1\|	19	g16634	i0	86.538	158.898550724638	260	27	93	7	10	267	1983	1730	Pelobacter carbinolicus strain Gra Bd 1 23S ribosomal RNA gene, complete sequence	blastn	43856	281	0.99288256227758	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Syntrophotaleaceae	Syntrophotalea	Syntrophotalea carbinolica
6234275	6234275	PRJNA561212_P_NODE_3845_length_564_cov_0.881874_g3638_i0	PRJNA561212	3845	564	0.881874	4.97376936	Nitratidesulfovibrio	2802295	Bacteria	Bacteria	989	0	NTclustered	gi\|2791413552\|dbj\|AP036014.1\|	2009266	g3638	i0	99.449	277	544	3	96	0	10	553	226840	226297	Nitratidesulfovibrio sp. HK-II DNA, complete genome	blastn	156228	994	0.994969818913481	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio sp. HK-II
7508647	7508647	PRJNA561212_P_NODE_14886_length_291_cov_1.279817_g14675_i0	PRJNA561212	14886	291	1.279817	3.72426747	Desulfocurvibacter	2582840	Bacteria	Bacteria	283	8.78e-72	NTclustered	gi\|470489697\|ref\|NR_076945.1\|	873	g14675	i0	85.348	87.9209621993127	273	40	94	0	10	282	496	224	Desulfovibrio africanus strain Walvis Bay 23S ribosomal RNA gene, complete sequence	blastn	25585	283	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfocurvibacter	Desulfocurvibacter africanus
10749861	10749861	PRJNA561212_P_NODE_6709_length_425_cov_1.909091_g6498_i0	PRJNA561212	6709	425	1.909091	8.11363675	Desulfuromonadaceae bacterium	2099677	Bacteria	Bacteria	218	1.6e-64	NR	MDD2735523.1	2099677	g6498	i0	75.4	19.5811764705882	130	32	91.8	0	11	400	198	327	MDD2735523.1 acetyl/propionyl/methylcrotonyl-CoA carboxylase subunit alpha [Desulfuromonadaceae bacterium]	diamond	8322	218	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae		Desulfuromonadaceae bacterium
15848093	15848093	PRJNA561212_P_NODE_11193_length_331_cov_1.290698_g10982_i0	PRJNA561212	11193	331	1.290698	4.27221038	Desulfovibrionales bacterium	2448050	Bacteria	Bacteria	139	7.09e-37	NR	MDK2957425.1	2448050	g10982	i0	63.6	4.84894259818731	107	39	97	0	10	330	207	313	MDK2957425.1 ammonium transporter, Amt family [Desulfovibrionales bacterium]	diamond	1605	139	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales			Desulfovibrionales bacterium
19671822	19671822	PRJNA561212_P_NODE_15556_length_286_cov_1.056338_g15345_i0	PRJNA561212	15556	286	1.056338	3.02112668	Nitratidesulfovibrio sp. HK-II	2009266	Bacteria	Bacteria	496	1.02e-135	NTclustered	gi\|2791413552\|dbj\|AP036014.1\|	2009266	g15345	i0	100	171.195804195804	268	0	94	0	10	277	225787	225520	Nitratidesulfovibrio sp. HK-II DNA, complete genome	blastn	48962	496	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio sp. HK-II
22222531	22222531	PRJNA561212_P_NODE_3298_length_608_cov_2.216822_g3092_i0	PRJNA561212	3298	608	2.216822	13.47827776	Desulfopila aestuarii	231440	Bacteria	Bacteria	221	4.45e-65	NR	WP_084554044.1	231440	g3092	i0	61.4	1.63322368421053	166	64	81.9	0	503	6	61	226	WP_084554044.1 NAD-dependent malic enzyme [Desulfopila aestuarii]	diamond	993	221	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfopila	Desulfopila aestuarii
23497782	23497782	PRJNA561212_P_NODE_22199_length_249_cov_0.886364_g21988_i0	PRJNA561212	22199	249	0.886364	2.20704636	Nitratidesulfovibrio sp. HK-II	2009266	Bacteria	Bacteria	424	4.15e-114	NTclustered	gi\|2791413552\|dbj\|AP036014.1\|	2009266	g21988	i0	99.569	335.534136546185	232	1	93	0	9	240	227377	227608	Nitratidesulfovibrio sp. HK-II DNA, complete genome	blastn	83548	424	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio sp. HK-II
27029730	27029730	PRJNA561212_P_NODE_4162_length_543_cov_1.280851_g3954_i0	PRJNA561212	4162	543	1.280851	6.95502093	Pseudomonadati	3379134	Bacteria	Bacteria	48.1	0.00534	NR	WP_054032100.1	1185843	g3954	i0	36	1.34254143646409	75	46	40.3	1	221	3	145	219	WP_054032100.1 acyl-[acyl-carrier-protein] thioesterase [Desulfatitalea tepidiphila]	diamond	729	48.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfatitalea	Desulfatitalea tepidiphila
28815692	28815692	PRJNA561212_P_NODE_20868_length_252_cov_0.871508_g20657_i0	PRJNA561212	20868	252	0.871508	2.19620016	Desulfobulbaceae bacterium	2053307	Bacteria	Bacteria	76.3	5.44e-14	NR	MDH3360222.1	2053307	g20657	i0	43.6	0.928571428571429	78	36	92.9	1	251	18	96	165	MDH3360222.1 PatB family C-S lyase [Desulfobulbaceae bacterium]	diamond	234	76.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium
29555950	29555950	PRJNA561212_P_NODE_17170_length_274_cov_1.079602_g16959_i0	PRJNA561212	17170	274	1.079602	2.95810948	Pseudomonadati	3379134	Bacteria	Bacteria	76.3	8.37e-14	NR	WP_022854294.1	501497	g16959	i0	47.6	4.74087591240876	84	39	92	1	262	11	336	414	WP_022854294.1 threonine synthase [Thermodesulfatator atlanticus]	diamond	1299	77	0.990909090909091	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Thermodesulfobacteria	Thermodesulfobacteriales	Thermodesulfatatoraceae	Thermodesulfatator	Thermodesulfatator atlanticus
30868904	30868904	PRJNA561212_P_NODE_8754_length_371_cov_1.637584_g8543_i0	PRJNA561212	8754	371	1.637584	6.07543664	Desulfobulbaceae bacterium AR3	2202841	Bacteria	Bacteria	77	5.14e-14	NR	MCI5144549.1	2202841	g8543	i0	36.8	0.946091644204852	117	70	92.2	2	351	10	44	159	MCI5144549.1 endonuclease/exonuclease/phosphatase family protein [Candidatus Electrothrix sp. AR3]	diamond	351	77	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium AR3

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