contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJEB10140" and tax_kingdom = "Thermoproteati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13252 | 13252 | PRJEB10140_P_NODE_58261_length_629_cov_7.518966_g41685_i0 | PRJEB10140 | 58261 | 629 | 7.518966 | 47.29429614 | Saccharolobus caldissimus | 1702097 | Archaea | Archaea | 54.7 | 0.017 | NTclustered | gi|2129441369|dbj|AP025226.1| | 1702097 | g41685 | i0 | 100 | 0.0461049284578696 | 29 | 0 | 5 | 0 | 175 | 203 | 866123 | 866095 | Saccharolobus caldissimus JCM32116 DNA, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Saccharolobus | Saccharolobus caldissimus | ||
| 8635331 | 8635331 | PRJEB10140_P_NODE_243827_length_169_cov_1.733333_g226518_i0 | PRJEB10140 | 243827 | 169 | 1.733333 | 2.92933277 | Candidatus Nitrosomarinus | 1993653 | Archaea | Archaea | 54.7 | 0.004 | NTclustered | gi|1196088602|gb|CP021324.1| | 1898749 | g226518 | i0 | 100 | 0.343195266272189 | 29 | 0 | 17 | 0 | 36 | 64 | 1351901 | 1351873 | Candidatus Nitrosomarinus catalina strain SPOT01 chromosome, complete genome | blastn | 58 | 54.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Candidatus Nitrosomarinus | Candidatus Nitrosomarinus catalinensis | ||
| 11489924 | 11489924 | PRJEB10140_P_NODE_192710_length_201_cov_1.368421_g175401_i0 | PRJEB10140 | 192710 | 201 | 1.368421 | 2.75052621 | Acidianus ambivalens | 2283 | Archaea | Archaea | 62.1 | 2.9e-5 | NTclustered | gi|1780181985|gb|CP045482.1| | 2283 | g175401 | i0 | 93.182 | 0.766169154228856 | 44 | 0 | 20 | 2 | 81 | 121 | 2242076 | 2242033 | Acidianus ambivalens strain LEI 10 chromosome, complete genome | blastn | 154 | 62.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Acidianus | Acidianus ambivalens | ||
| 16588581 | 16588581 | PRJEB10140_P_NODE_149974_length_247_cov_2.020202_g132666_i0 | PRJEB10140 | 149974 | 247 | 2.020202 | 4.98989894 | Candidatus Nitrosomarinus catalinensis | 1898749 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|1196088602|gb|CP021324.1| | 1898749 | g132666 | i0 | 100 | 0.11336032388664 | 28 | 0 | 11 | 0 | 192 | 219 | 1213542 | 1213515 | Candidatus Nitrosomarinus catalina strain SPOT01 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Candidatus Nitrosomarinus | Candidatus Nitrosomarinus catalinensis | ||
| 19136979 | 19136979 | PRJEB10140_P_NODE_114316_length_319_cov_3.100000_g97010_i0 | PRJEB10140 | 114316 | 319 | 3.1 | 9.889 | Thermoproteus uzoniensis | 184117 | Archaea | Archaea | 52.8 | 0.03 | NTclustered | gi|326946401|gb|CP002590.1| | 999630 | g97010 | i0 | 100 | 0.0877742946708464 | 28 | 0 | 9 | 0 | 4 | 31 | 1601335 | 1601308 | Thermoproteus uzoniensis 768-20, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Thermoproteus | Thermoproteus uzoniensis | ||
| 20413483 | 20413483 | PRJEB10140_P_NODE_277517_length_164_cov_0.904348_g260208_i0 | PRJEB10140 | 277517 | 164 | 0.904348 | 1.48313072 | Vulcanisaeta moutnovskia | 985052 | Archaea | Archaea | 52.8 | 0.014 | NTclustered | gi|323706731|gb|CP002529.1| | 985053 | g260208 | i0 | 100 | 0.170731707317073 | 28 | 0 | 17 | 0 | 67 | 94 | 336127 | 336100 | Vulcanisaeta moutnovskia 768-28, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Vulcanisaeta | Vulcanisaeta moutnovskia | ||
| 22659265 | 22659265 | PRJEB10140_P_NODE_256198_length_167_cov_0.881356_g238889_i0 | PRJEB10140 | 256198 | 167 | 0.881356 | 1.47186452 | Sulfurisphaera | 69655 | Archaea | Archaea | 62.1 | 2.33e-5 | NTclustered | gi|1780177153|gb|CP045484.1| | 69656 | g238889 | i0 | 92.857 | 0.826347305389222 | 42 | 3 | 25 | 0 | 112 | 153 | 1204563 | 1204522 | Sulfurisphaera ohwakuensis strain TA-1 chromosome, complete genome | blastn | 138 | 62.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Sulfurisphaera | Sulfurisphaera ohwakuensis |
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);;