metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA493827" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA493827" 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
470687	470687	PRJNA493827_P_NODE_151501_length_278_cov_1.502439_g149303_i0	PRJNA493827	151501	278	1.502439	4.17678042	Syntrophales bacterium	2928017	Bacteria	Bacteria	139	1.91e-28	NTclustered	gi\|2621703594\|emb\|OY761459.1\|	2928017	g149303	i0	82.716	160.931654676259	162	22	57	6	53	210	1397960	1398119	MAG: Syntrophales bacterium isolate c6a0f7f3-880d-44d6-9c5f-266f97196533 genome assembly, chromosome: 1	blastn	44739	139	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales bacterium
470829	470829	PRJNA493827_P_NODE_158221_length_272_cov_1.859296_g156023_i0	PRJNA493827	158221	272	1.859296	5.05728512	Smithellaceae bacterium	2964540	Bacteria	Bacteria	285	2.26e-72	NTclustered	gi\|2626216295\|emb\|OY821638.1\|	2964540	g156023	i0	85.821	0.985294117647059	268	38	99	0	5	272	4802039	4801772	MAG: Smithellaceae bacterium isolate 7d888188-1d27-4603-a379-950c855845c6 genome assembly, chromosome: 1	blastn	268	285	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae		Smithellaceae bacterium
6208358	6208358	PRJNA493827_P_NODE_159085_length_271_cov_5.151515_g156887_i0	PRJNA493827	159085	271	5.151515	13.96060565	Desulfonema	45654	Bacteria	Bacteria	265	2.93e-66	NTclustered	gi\|2007135636\|gb\|CP061800.1\|	45655	g156887	i0	88.341	136.09594095941	223	23	82	3	39	259	7419141	7419362	Desulfonema magnum strain 4be13 chromosome, complete genome	blastn	36882	265	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfonema	Desulfonema magnum
6208710	6208710	PRJNA493827_P_NODE_209765_length_246_cov_0.890173_g207567_i0	PRJNA493827	209765	246	0.890173	2.18982558	Geobacter	28231	Bacteria	Bacteria	182	2.72e-41	NTclustered	gi\|779731694\|gb\|CP010430.1\|	35554	g207567	i0	81.982	132.524390243902	222	33	88	5	30	246	1229621	1229840	Geobacter sulfurreducens strain AM-1 genome	blastn	32601	182	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
6851871	6851871	PRJNA493827_P_NODE_92566_length_356_cov_3.201413_g90368_i0	PRJNA493827	92566	356	3.201413	11.39703028	uncultured Desulfobulbus sp.	239745	Bacteria	Bacteria	58.4	7.24e-4	NTclustered	gi\|2621704320\|emb\|OY760916.1\|	239745	g90368	i0	100	0.775280898876405	31	0	9	0	326	356	4608661	4608691	MAG: uncultured Desulfobulbus sp. isolate 7a05128d-adad-4d17-beb6-ff3d102eb21b genome assembly, chromosome: 1	blastn	276	58.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	uncultured Desulfobulbus sp.
8758105	8758105	PRJNA493827_P_NODE_181547_length_253_cov_1.227778_g179349_i0	PRJNA493827	181547	253	1.227778	3.10627834	Pseudomonadati	3379134	Bacteria	Bacteria	237	5.899999999999999e-58	NTclustered	gi\|470477521\|ref\|NR_076389.1\|	28232	g179349	i0	83.984	192.845849802372	256	31	100	9	1	253	276	28	Geobacter metallireducens strain GS-15 23S ribosomal RNA gene, complete sequence	blastn	48790	239	0.99163179916318	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter metallireducens
10673451	10673451	PRJNA493827_P_NODE_113889_length_320_cov_1.894737_g111691_i0	PRJNA493827	113889	320	1.894737	6.0631584	Candidatus Desulfofervidus auxilii	1621989	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|1001906061\|gb\|CP013015.1\|	1621989	g111691	i0	100	0.0875	28	0	9	0	111	138	267126	267153	Candidatus Desulfofervidus auxilii strain HS1 genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Desulfofervidia	Candidatus Desulfofervidales	Candidatus Desulfofervidaceae	Candidatus Desulfofervidus	Candidatus Desulfofervidus auxilii
17049018	17049018	PRJNA493827_P_NODE_204114_length_247_cov_0.885057_g201916_i0	PRJNA493827	204114	247	0.885057	2.18609079	Syntrophobacter fumaroxidans	119484	Bacteria	Bacteria	63.9	1.03e-5	NTclustered	gi\|116696516\|gb\|CP000478.1\|	335543	g201916	i0	91.489	13.3684210526316	47	3	19	1	139	185	4546388	4546343	Syntrophobacter fumaroxidans MPOB, complete genome	blastn	3302	63.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Syntrophobacter	Syntrophobacter fumaroxidans
19599299	19599299	PRJNA493827_P_NODE_57796_length_464_cov_1.578005_g55601_i0	PRJNA493827	57796	464	1.578005	7.3219432	Pseudodesulfovibrio portus	231439	Bacteria	Bacteria	65.8	5.79e-6	NTclustered	gi\|2296712847\|dbj\|AP026708.1\|	231439	g55601	i0	97.368	2.15948275862069	38	1	8	0	96	133	3040293	3040256	Pseudodesulfovibrio portus JCM 14722 DNA, complete genome	blastn	1002	65.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio portus
20872722	20872722	PRJNA493827_P_NODE_167177_length_265_cov_1.078125_g164979_i0	PRJNA493827	167177	265	1.078125	2.85703125	Smithellaceae bacterium	2964540	Bacteria	Bacteria	95.3	3.97e-15	NTclustered	gi\|2626214512\|emb\|OY820932.1\|	2964540	g164979	i0	86.207	20.1622641509434	87	12	33	0	161	247	611422	611508	MAG: Smithellaceae bacterium isolate 90efb5c7-b315-4df1-98b9-9b59cc098579 genome assembly, chromosome: 1	blastn	5343	95.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae		Smithellaceae bacterium
22148205	22148205	PRJNA493827_P_NODE_202198_length_247_cov_1.327586_g200000_i0	PRJNA493827	202198	247	1.327586	3.27913742	uncultured Desulforhopalus sp.	218291	Bacteria	Bacteria	261	3.41e-65	NTclustered	gi\|2621785518\|emb\|OY781976.1\|	218291	g200000	i0	85.887	240.825910931174	248	31	99	3	3	247	5452488	5452242	MAG: uncultured Desulforhopalus sp. isolate bb11d97f-aff7-40c5-8ccb-5babbf234ee9 genome assembly, chromosome: 1	blastn	59484	261	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulforhopalus	uncultured Desulforhopalus 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);;