metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJEB58983" and tax

9 rows where analysis = "blastn", bioproject = "PRJEB58983" 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
992130	992130	PRJEB58983_P_NODE_25661_length_262_cov_1.280423_g25246_i0	PRJEB58983	25661	262	1.280423	3.35470826	Desulfocapsaceae	2886822	Bacteria	Bacteria	110	1.4e-19	NTclustered	gi\|2557433592\|gb\|CP050700.1\|	2653858	g25246	i0	88.889	19.9198473282443	90	8	34	2	16	104	5809087	5809175	Desulfopila sp. IMCC35008 chromosome, complete genome	blastn	5219	110	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfopila	Desulfopila sp. IMCC35008
5227583	5227583	PRJEB58983_P_NODE_29605_length_248_cov_2.668571_g29190_i0	PRJEB58983	29605	248	2.668571	6.61805608	Desulfovibrionaceae bacterium	2049043	Bacteria	Bacteria	124	4.6899999999999996e-24	NTclustered	gi\|2621705002\|emb\|OY762289.1\|	2049043	g29190	i0	79.365	107.689516129032	189	30	75	7	62	246	713055	713238	MAG: Desulfovibrionaceae bacterium isolate 1e2121d5-5174-4668-bae3-9852897706ae genome assembly, chromosome: 1	blastn	26707	124	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae		Desulfovibrionaceae bacterium
9051857	9051857	PRJEB58983_P_NODE_10968_length_379_cov_2.395425_g10553_i0	PRJEB58983	10968	379	2.395425	9.07866075	Geoalkalibacter subterraneus	483547	Bacteria	Bacteria	385	3.14e-102	NTclustered	gi\|749207097\|gb\|CP010311.1\|	483547	g10553	i0	85.224	207.018469656992	379	50	99	6	3	379	2609394	2609768	Geoalkalibacter subterraneus strain Red1, complete genome	blastn	78460	385	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geoalkalibacteraceae	Geoalkalibacter	Geoalkalibacter subterraneus
9051974	9051974	PRJEB58983_P_NODE_16628_length_315_cov_1.190083_g16213_i0	PRJEB58983	16628	315	1.190083	3.74876145	Geoalkalibacter subterraneus	483547	Bacteria	Bacteria	257	5.8200000000000005e-64	NTclustered	gi\|749207097\|gb\|CP010311.1\|	483547	g16213	i0	85.433	112.946031746032	254	29	79	6	4	251	2609607	2609356	Geoalkalibacter subterraneus strain Red1, complete genome	blastn	35578	257	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geoalkalibacteraceae	Geoalkalibacter	Geoalkalibacter subterraneus
14153599	14153599	PRJEB58983_P_NODE_6572_length_481_cov_2.549020_g6158_i0	PRJEB58983	6572	481	2.54902	12.2607862	uncultured Desulfobacterium sp.	201089	Bacteria	Bacteria	224	9.379999999999999e-54	NTclustered	gi\|2621713419\|emb\|OY771474.1\|	201089	g6158	i0	76.008	132.047817047817	471	91	96	17	1	459	1758350	1758810	MAG: uncultured Desulfobacterium sp. isolate 2c08e38e-77a0-468a-b8ca-c683eacf49f2 genome assembly, chromosome: 1	blastn	63515	224	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteriaceae	Desulfobacterium	uncultured Desulfobacterium sp.
21394201	21394201	PRJEB58983_P_NODE_29677_length_248_cov_1.954286_g29262_i0	PRJEB58983	29677	248	1.954286	4.84662928	Geotalea	2910589	Bacteria	Bacteria	292	1.21e-74	NTclustered	gi\|221562406\|gb\|CP001390.1\|	316067	g29262	i0	90.498	171.733870967742	221	21	89	0	28	248	2115197	2114977	Geobacter daltonii FRC-32, complete genome	blastn	42590	292	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geotalea	Geotalea daltonii
21801628	21801628	PRJEB58983_P_NODE_23618_length_271_cov_3.040404_g23203_i0	PRJEB58983	23618	271	3.040404	8.23949484	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	189	1.8199999999999998e-43	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g23203	i0	87.349	120.516605166052	166	20	61	1	96	261	1711957	1711793	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	32660	189	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
21801742	21801742	PRJEB58983_P_NODE_28458_length_251_cov_2.157303_g28043_i0	PRJEB58983	28458	251	2.157303	5.41483053	uncultured Desulfuromonas sp.	181013	Bacteria	Bacteria	159	1.3e-34	NTclustered	gi\|2621704006\|emb\|OY762961.1\|	181013	g28043	i0	82.796	2.14741035856574	186	24	73	7	5	186	318391	318572	MAG: uncultured Desulfuromonas sp. isolate cad01da2-5f99-43ef-8b90-e7e0a75d6a39 genome assembly, chromosome: 1	blastn	539	159	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	uncultured Desulfuromonas sp.
21801880	21801880	PRJEB58983_P_NODE_35498_length_202_cov_4.821705_g35083_i0	PRJEB58983	35498	202	4.821705	9.7398441	Desulfosarcina alkanivorans	571177	Bacteria	Bacteria	176	1e-39	NTclustered	gi\|1773409569\|dbj\|AP021874.1\|	571177	g35083	i0	86.228	97.1831683168317	167	17	81	5	1	164	2620235	2620398	Desulfosarcina alkanivorans PL12 DNA, complete genome	blastn	19631	176	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	Desulfosarcina alkanivorans

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