contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA429937" and tax_superkingdom = "Archaea"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4254121 | 4254121 | PRJNA429937_P_NODE_65184_length_423_cov_3.271574_g26173_i1 | PRJNA429937 | 65184 | 423 | 3.271574 | 13.83875802 | Acidianus brierleyi | 41673 | Archaea | Archaea | 52.8 | 0.041 | NTclustered | gi|1820310180|gb|CP029289.2| | 41673 | g26173 | i1 | 100 | 0.066193853427896 | 28 | 0 | 7 | 0 | 395 | 422 | 833643 | 833670 | Acidianus brierleyi strain DSM 1651 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Acidianus | Acidianus brierleyi | ||
| 5530179 | 5530179 | PRJNA429937_P_NODE_31305_length_650_cov_2.834138_g19109_i0 | PRJNA429937 | 31305 | 650 | 2.834138 | 18.421897 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 1053 | 0 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g19109 | i0 | 99.314 | 0.987692307692308 | 583 | 2 | 98 | 2 | 1 | 581 | 2820740 | 2820158 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 642 | 1053 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 9354629 | 9354629 | PRJNA429937_P_NODE_31308_length_650_cov_2.732689_g19109_i1 | PRJNA429937 | 31308 | 650 | 2.732689 | 17.7624785 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 1053 | 0 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g19109 | i1 | 99.314 | 0.987692307692308 | 583 | 2 | 98 | 2 | 1 | 581 | 2820740 | 2820158 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 642 | 1053 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 10629543 | 10629543 | PRJNA429937_P_NODE_113529_length_265_cov_3.012712_g90906_i0 | PRJNA429937 | 113529 | 265 | 3.012712 | 7.9836868 | Haloarcula regularis | 3033392 | Archaea | Archaea | 198 | 2.94e-46 | NTclustered | gi|2463595546|gb|CP119795.1| | 3033392 | g90906 | i0 | 88.485 | 0.9660377358490572 | 165 | 17 | 96 | 2 | 102 | 265 | 99853 | 99690 | Haloarcula regularis strain SYNS111 plasmid unnamed1, complete sequence | blastn | 256 | 198 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula regularis | |
| 11905897 | 11905897 | PRJNA429937_P_NODE_62550_length_435_cov_3.105911_g42350_i0 | PRJNA429937 | 62550 | 435 | 3.105911 | 13.510712850000001 | Haloarcula regularis | 3033392 | Archaea | Archaea | 298 | 4.89e-76 | NTclustered | gi|2463595546|gb|CP119795.1| | 3033392 | g42350 | i0 | 85.763 | 1.59080459770115 | 295 | 26 | 65 | 9 | 154 | 435 | 99562 | 99853 | Haloarcula regularis strain SYNS111 plasmid unnamed1, complete sequence | blastn | 692 | 298 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula regularis | |
| 11906008 | 11906008 | PRJNA429937_P_NODE_69010_length_407_cov_2.304233_g47626_i0 | PRJNA429937 | 69010 | 407 | 2.304233 | 9.37822831 | Haloarcula regularis | 3033392 | Archaea | Archaea | 198 | 4.74e-46 | NTclustered | gi|2463595546|gb|CP119795.1| | 3033392 | g47626 | i0 | 88.485 | 0.734643734643735 | 165 | 17 | 73 | 2 | 1 | 164 | 99690 | 99853 | Haloarcula regularis strain SYNS111 plasmid unnamed1, complete sequence | blastn | 299 | 198 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula regularis | |
| 15730307 | 15730307 | PRJNA429937_P_NODE_93833_length_321_cov_2.071918_g71243_i0 | PRJNA429937 | 93833 | 321 | 2.071918 | 6.65085678 | Methanobacterium sp. MB1 | 1379702 | Archaea | Archaea | 448 | 3.289999999999999e-121 | NTclustered | gi|557945513|emb|HG425166.1| | 1379702 | g71243 | i0 | 99.197 | 7.08722741433022 | 249 | 0 | 98 | 2 | 9 | 255 | 743204 | 742956 | Methanobacterium sp. MB1 complete sequence | blastn | 2275 | 448 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. MB1 | |
| 24653019 | 24653019 | PRJNA429937_P_NODE_42300_length_552_cov_3.936902_g26907_i0 | PRJNA429937 | 42300 | 552 | 3.936902 | 21.73169904 | Candidatus Methanoperedens sp. | 2032688 | Archaea | Archaea | 477 | 7.56e-130 | NTclustered | gi|2388573995|gb|CP113312.1| | 2032688 | g26907 | i0 | 88.776 | 0.710144927536232 | 392 | 40 | 71 | 4 | 163 | 552 | 14392 | 14781 | MAG: Candidatus Methanoperedens sp. isolate v3 plasmid unnamed | blastn | 392 | 477 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Candidatus Methanoperedentaceae | Candidatus Methanoperedens | Candidatus Methanoperedens 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);;