metadata: contig_metadata: 13 rows where bioproject = "PRJNA400391", tax_kingdom = "Pseudomonadati" and tax

13 rows where bioproject = "PRJNA400391", 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
414010	414010	PRJNA400391_S_NODE_3081_length_229_cov_3.489691_g3020_i0	PRJNA400391	3081	229	3.489691	7.99139239	Desulfococcus multivorans	897	Bacteria	Bacteria	303	5.11e-78	NTclustered	gi\|1092202713\|gb\|CP015381.1\|	897	g3020	i0	96.703	197.03056768559	182	6	79	0	48	229	148044	147863	Desulfococcus multivorans strain DSM 2059 chromosome, complete genome	blastn	45120	303	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfococcus	Desulfococcus multivorans
414028	414028	PRJNA400391_S_NODE_3741_length_208_cov_4.843931_g3680_i0	PRJNA400391	3741	208	4.843931	10.07537648	Candidatus Electronema halotolerans	3036122	Bacteria	Bacteria	159	1.04e-34	NTclustered	gi\|2322424479\|emb\|OW818675.1\|	3036122	g3680	i0	86.486	68.5769230769231	148	16	70	3	1	146	2404305	2404160	Candidatus Electronema halotolerans isolate LOGT-cMAG genome assembly, chromosome: 1	blastn	14264	159	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electronema	Candidatus Electronema halotolerans
7458951	7458951	PRJNA400391_S_NODE_1966_length_281_cov_469.918699_g1905_i0	PRJNA400391	1966	281	469.918699	1320.47154419	Pseudomonadati	3379134	Bacteria	Bacteria	324	4.97e-84	NTclustered	gi\|779731694\|gb\|CP010430.1\|	35554	g1905	i0	88.476	241.79359430605	269	30	95	1	14	281	2785241	2784973	Geobacter sulfurreducens strain AM-1 genome	blastn	67944	327	0.990825688073395	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
8067442	8067442	PRJNA400391_S_NODE_5927_length_161_cov_1.841270_g5866_i0	PRJNA400391	5927	161	1.84127	2.9644447	Desulfococcus multivorans	897	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|1092202713\|gb\|CP015381.1\|	897	g5866	i0	100	294.018633540373	161	0	100	0	1	161	145321	145161	Desulfococcus multivorans strain DSM 2059 chromosome, complete genome	blastn	47337	298	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfococcus	Desulfococcus multivorans
9342244	9342244	PRJNA400391_S_NODE_3648_length_211_cov_3.522727_g3587_i0	PRJNA400391	3648	211	3.522727	7.43295397	Geobacter benzoatilyticus	2815309	Bacteria	Bacteria	154	4.94e-33	NTclustered	gi\|2004017374\|gb\|CP071382.1\|	2815309	g3587	i0	80.374	69.9905213270142	214	33	99	8	3	211	489813	490022	Geobacter benzoatilyticus strain Jerry-YX chromosome, complete genome	blastn	14768	154	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter benzoatilyticus
10618027	10618027	PRJNA400391_S_NODE_5329_length_171_cov_3.360294_g5268_i0	PRJNA400391	5329	171	3.360294	5.74610274	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	209	8.03e-50	NTclustered	gi\|2893358418\|emb\|OZ220710.1\|	2202153	g5268	i0	89.82	100.286549707602	167	11	96	4	1	164	2289670	2289507	MAG: Thermodesulfobacteriota bacterium isolate dce1034a-8f23-488c-aa07-39e6c80a0035 genome assembly, chromosome: 1	blastn	17149	209	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
11284318	11284318	PRJNA400391_S_NODE_2649_length_246_cov_3.530806_g2588_i0	PRJNA400391	2649	246	3.530806	8.68578276	Geomonas	2651583	Bacteria	Bacteria	357	4.1999999999999997e-94	NTclustered	gi\|2233265061\|gb\|CP096574.1\|	2740185	g2588	i0	93.089	184.020325203252	246	14	99	3	2	245	885189	884945	Geomonas paludis strain RG22 chromosome, complete genome	blastn	45269	357	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas paludis
14442994	14442994	PRJNA400391_S_NODE_3052_length_230_cov_6.723077_g2991_i0	PRJNA400391	3052	230	6.723077	15.4630771	Desulfarculia bacterium	3065862	Bacteria	Bacteria	115	2.58e-21	NTclustered	gi\|2621702698\|emb\|OY759590.1\|	3065862	g2991	i0	84	87.6739130434783	125	14	53	6	110	230	337014	336892	MAG: Desulfarculia bacterium isolate 49400898-fc5b-42b7-bef8-a303f8702bb8 genome assembly, chromosome: 1	blastn	20165	115	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia				Desulfarculia bacterium
16383395	16383395	PRJNA400391_S_NODE_1133_length_345_cov_158.312903_g1072_i0	PRJNA400391	1133	345	158.312903	546.17951535	Thermodesulfobacteriota	200940	Bacteria	Bacteria	473	5.879999999999999e-129	NTclustered	gi\|470477500\|ref\|NR_076387.1\|	19	g1072	i0	91.988	273.869565217391	337	27	98	0	9	345	2292	2628	Pelobacter carbinolicus strain Gra Bd 1 23S ribosomal RNA gene, complete sequence	blastn	94485	473	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Syntrophotaleaceae	Syntrophotalea	Syntrophotalea carbinolica
18932561	18932561	PRJNA400391_S_NODE_5515_length_168_cov_3.428571_g5454_i0	PRJNA400391	5515	168	3.428571	5.75999928	Candidatus Electrothrix	1859128	Bacteria	Bacteria	108	2.97e-19	NTclustered	gi\|2755823080\|gb\|CP159373.1\|	3062594	g5454	i0	85.577	296.964285714286	104	14	62	1	64	167	143032	143134	MAG: Candidatus Electrothrix aestuarii isolate Rat1 chromosome, complete genome	blastn	49890	108	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electrothrix	Candidatus Electrothrix aestuarii
20815764	20815764	PRJNA400391_S_NODE_5357_length_171_cov_1.227941_g5296_i0	PRJNA400391	5357	171	1.227941	2.09977911	Desulfarculaceae bacterium	2528248	Bacteria	Bacteria	113	6.480000000000001e-21	NTclustered	gi\|2621780225\|emb\|OY776512.1\|	2528248	g5296	i0	81.379	111.93567251462	145	22	84	5	1	144	4510135	4509995	MAG: Desulfarculaceae bacterium isolate e2237022-3439-453f-a1e0-3d3180ebaa11 genome assembly, chromosome: 1	blastn	19141	113	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae		Desulfarculaceae bacterium
23366186	23366186	PRJNA400391_S_NODE_4999_length_177_cov_2.239437_g4938_i0	PRJNA400391	4999	177	2.239437	3.96380349	Candidatus Electronema aureum	2005002	Bacteria	Bacteria	156	1.11e-33	NTclustered	gi\|2322424202\|emb\|OW818638.1\|	2005002	g4938	i0	82.857	205.372881355932	175	29	98	1	1	174	1681	1855	Candidatus Electronema aureum isolate ENR-cMAG genome assembly, chromosome: 1	blastn	36351	156	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electronema	Candidatus Electronema aureum
25307207	25307207	PRJNA400391_S_NODE_5100_length_175_cov_1.628571_g5039_i0	PRJNA400391	5100	175	1.628571	2.84999925	Nitratidesulfovibrio	2802295	Bacteria	Bacteria	207	2.97e-49	NTclustered	gi\|2791413552\|dbj\|AP036014.1\|	2009266	g5039	i0	90.062	145.194285714286	161	14	91	2	7	166	226551	226710	Nitratidesulfovibrio sp. HK-II DNA, complete genome	blastn	25409	207	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio sp. HK-II

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