metadata: contig_metadata: 11 rows where bioproject = "PRJNA414036", tax_kingdom = "Pseudomonadati" and tax

11 rows where bioproject = "PRJNA414036", 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
1693678	1693678	PRJNA414036_P_NODE_80222_length_162_cov_5.551181_g78483_i0	PRJNA414036	80222	162	5.551181	8.99291322	Candidatus Desulfofervidus auxilii	1621989	Bacteria	Bacteria	84.2	4.78e-12	NTclustered	gi\|1001906061\|gb\|CP013015.1\|	1621989	g78483	i0	85.366	0.506172839506173	82	10	50	2	8	88	265723	265643	Candidatus Desulfofervidus auxilii strain HS1 genome	blastn	82	84.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Desulfofervidia	Candidatus Desulfofervidales	Candidatus Desulfofervidaceae	Candidatus Desulfofervidus	Candidatus Desulfofervidus auxilii
5522486	5522486	PRJNA414036_P_NODE_27445_length_287_cov_1832.051587_g25710_i0	PRJNA414036	27445	287	1832.051587	5257.98805469	Geobacter benzoatilyticus	2815309	Bacteria	Bacteria	255	1.88e-63	NTclustered	gi\|2004017374\|gb\|CP071382.1\|	2815309	g25710	i0	83.333	209.020905923345	282	41	97	5	1	278	488885	489164	Geobacter benzoatilyticus strain Jerry-YX chromosome, complete genome	blastn	59989	255	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter benzoatilyticus
7460891	7460891	PRJNA414036_P_NODE_55726_length_230_cov_16.441026_g53987_i0	PRJNA414036	55726	230	16.441026	37.8143598	Desulfotalea	109168	Bacteria	Bacteria	69.4	2.04e-7	NTclustered	gi\|470490570\|ref\|NR_076996.1\|	84980	g53987	i0	91.837	33.8434782608696	49	4	21	0	10	58	657	609	Desulfotalea psychrophila strain LSv54 23S ribosomal RNA gene, complete sequence	blastn	7784	69.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfotalea	Desulfotalea psychrophila
11286173	11286173	PRJNA414036_P_NODE_22929_length_316_cov_17.711744_g21198_i0	PRJNA414036	22929	316	17.711744	55.96911104	Thermodesulfobacteriota	200940	Bacteria	Bacteria	156	2.19e-33	NTclustered	gi\|470481149\|ref\|NR_076457.1\|	119484	g21198	i0	79.204	16.0917721518987	226	46	72	1	83	308	2327	2551	Syntrophobacter fumaroxidans strain MPOB 23S ribosomal RNA gene, complete sequence	blastn	5085	156	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Syntrophobacter	Syntrophobacter fumaroxidans
13172555	13172555	PRJNA414036_P_NODE_68451_length_187_cov_68.815789_g66712_i0	PRJNA414036	68451	187	68.815789	128.68552543	uncultured Desulfobacterium sp.	201089	Bacteria	Bacteria	104	4.36e-18	NTclustered	gi\|2621785015\|emb\|OY781473.1\|	201089	g66712	i0	77.778	55.5080213903743	171	36	90	2	17	185	2493372	2493202	MAG: uncultured Desulfobacterium sp. isolate b5edb3ca-a369-423b-9e9e-493c49de4e5b genome assembly, chromosome: 1	blastn	10380	104	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteriaceae	Desulfobacterium	uncultured Desulfobacterium sp.
15721353	15721353	PRJNA414036_P_NODE_22893_length_317_cov_2.173759_g21162_i0	PRJNA414036	22893	317	2.173759	6.89081603	Caldimicrobium thiodismutans	1653476	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|972621738\|dbj\|AP014945.1\|	1653476	g21162	i0	100	0.0883280757097792	28	0	9	0	71	98	1388530	1388557	Caldimicrobium thiodismutans DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Thermodesulfobacteria	Thermodesulfobacteriales	Thermodesulfobacteriaceae	Caldimicrobium	Caldimicrobium thiodismutans
18270418	18270418	PRJNA414036_P_NODE_64815_length_198_cov_24.871166_g63076_i0	PRJNA414036	64815	198	24.871166	49.24490868	uncultured Desulforhopalus sp.	218291	Bacteria	Bacteria	60.2	1.03e-4	NTclustered	gi\|2621785518\|emb\|OY781976.1\|	218291	g63076	i0	84.615	1.64141414141414	65	5	33	4	74	138	1357010	1357069	MAG: uncultured Desulforhopalus sp. isolate bb11d97f-aff7-40c5-8ccb-5babbf234ee9 genome assembly, chromosome: 1	blastn	325	60.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulforhopalus	uncultured Desulforhopalus sp.
19544608	19544608	PRJNA414036_P_NODE_5316_length_514_cov_96.661795_g1827_i2	PRJNA414036	5316	514	96.661795	496.8416263	uncultured Mailhella sp.	1981031	Bacteria	Bacteria	213	2.18e-50	NTclustered	gi\|2729058701\|emb\|OZ007001.1\|	1981031	g1827	i2	75.806	119.509727626459	496	79	94	34	20	504	1893422	1893887	MAG: uncultured Mailhella sp. isolate metabat2_pooled_hifiasm.920 MAG genome assembly, chromosome: 1	blastn	61428	213	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Mailhella	uncultured Mailhella sp.
22759886	22759886	PRJNA414036_P_NODE_34398_length_253_cov_15.082569_g32662_i0	PRJNA414036	34398	253	15.082569	38.15889957	Desulfotalea	109168	Bacteria	Bacteria	69.4	2.28e-7	NTclustered	gi\|470490570\|ref\|NR_076996.1\|	84980	g32662	i0	91.837	30.7667984189723	49	4	19	0	10	58	657	609	Desulfotalea psychrophila strain LSv54 23S ribosomal RNA gene, complete sequence	blastn	7784	69.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfotalea	Desulfotalea psychrophila
25309141	25309141	PRJNA414036_P_NODE_76200_length_169_cov_9.141791_g74461_i0	PRJNA414036	76200	169	9.141791	15.44962679	Desulfuromonas	890	Bacteria	Bacteria	126	8.2e-25	NTclustered	gi\|662020026\|ref\|NR_121913.1\|	891	g74461	i0	80.357	65.2189349112426	168	32	99	1	2	168	2817	2650	Desulfuromonas acetoxidans strain DSM 684 23S ribosomal RNA gene, complete sequence	blastn	11022	126	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas acetoxidans
30391985	30391985	PRJNA414036_P_NODE_65213_length_197_cov_4.104938_g63474_i0	PRJNA414036	65213	197	4.104938	8.08672786	uncultured Desulfobacterium sp.	201089	Bacteria	Bacteria	52.4	1.21e-6	NR	CBX28569.1	201089	g63474	i0	50.9	0.868020304568528	57	28	86.8	0	187	17	13	69	CBX28569.1 hypothetical protein N47_G38930 [uncultured Desulfobacterium sp.]	diamond	171	52.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteriaceae	Desulfobacterium	uncultured Desulfobacterium sp.

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