RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA939369" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA939369 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
2189624 2189624 PRJNA939369_S_NODE_24382_length_319_cov_1.020325_g23965_i0 PRJNA939369 24382 319 1.020325 3.25483675 Candidatus Nitrosopumilus sp. SW 2508726 Archaea Archaea 233 9.950000000000001e-57   NTclustered gi|1699461107|gb|CP035425.1| 2508726 g23965 i0 82.288 9.36050156739812 271 46 85 2 1 270 1026123 1025854 Candidatus Nitrosopumilus sp. SW chromosome, complete genome blastn 2986 233 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Candidatus Nitrosopumilus sp. SW
3808123 3808123 PRJNA939369_S_NODE_58363_length_249_cov_1.352273_g57946_i0 PRJNA939369 58363 249 1.352273 3.36715977 Nitrosopumilus 338191 Archaea Archaea 213 9.77e-51   NTclustered gi|1869224726|gb|CP026995.1| 1470067 g57946 i0 82.857 35.405622489959804 245 35 98 6 1 243 1660936 1660697 Nitrosopumilus ureiphilus strain PS0 chromosome, complete genome blastn 8816 213 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus ureiphilus
7292321 7292321 PRJNA939369_S_NODE_11666_length_403_cov_1.278788_g11249_i0 PRJNA939369 11666 403 1.278788 5.15351564 Nitrosopumilus zosterae 718286 Archaea Archaea 327 5.730000000000001e-85   NTclustered gi|2289589374|dbj|AP026695.1| 718286 g11249 i0 84.32 1.80893300248139 338 49 83 4 4 339 207010 206675 Nitrosopumilus zosterae NM25 DNA, complete genome blastn 729 327 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus zosterae
7634254 7634254 PRJNA939369_S_NODE_64786_length_246_cov_1.202312_g64369_i0 PRJNA939369 64786 246 1.202312 2.95768752 Thermoproteati 1783275 Archaea Archaea 449 6.74e-122   NTclustered gi|1276742682|gb|KY388028.1| 29281 g64369 i0 99.593 99.6544715447154 246 1 100 0 1 246 278 33 Uncultured crenarchaeote clone 2012JulP9S33 ammonia monooxygenase subunit A (amoA) gene, partial cds blastn 24515 449 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
12393669 12393669 PRJNA939369_S_NODE_58790_length_249_cov_0.875000_g58373_i0 PRJNA939369 58790 249 0.875 2.17875 Methanobrevibacter ruminantium 83816 Archaea Archaea 56.5 0.002   NTclustered gi|288541968|gb|CP001719.1| 634498 g58373 i0 100 0.120481927710843 30 0 12 0 147 176 2283316 2283287 Methanobrevibacter ruminantium M1, complete genome blastn 30 56.5 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter ruminantium
12735465 12735465 PRJNA939369_S_NODE_3850_length_598_cov_1.598095_g3444_i0 PRJNA939369 3850 598 1.598095 9.5566081 Nitrosopumilus 338191 Archaea Archaea 756 0   NTclustered gi|2289589374|dbj|AP026695.1| 718286 g3444 i0 89.482 22.685618729097 599 61 100 2 1 598 207854 207257 Nitrosopumilus zosterae NM25 DNA, complete genome blastn 13566 756 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus zosterae
14942170 14942170 PRJNA939369_S_NODE_23732_length_321_cov_1.524194_g23315_i0 PRJNA939369 23732 321 1.524194 4.89266274 Nitrosopumilus maritimus 338192 Archaea Archaea 228 4.659999999999999e-55   NTclustered gi|160338813|gb|CP000866.1| 436308 g23315 i0 80.063 2.70404984423676 316 55 96 4 13 321 1413014 1413328 Nitrosopumilus maritimus SCM1, complete genome blastn 868 228 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus maritimus
22591686 22591686 PRJNA939369_S_NODE_80798_length_199_cov_62.492063_g80381_i0 PRJNA939369 80798 199 62.492063 124.35920537 Vulcanisaeta moutnovskia 985052 Archaea Archaea 52.8 0.017   NTclustered gi|323706731|gb|CP002529.1| 985053 g80381 i0 100 0.14070351758794 28 0 14 0 152 179 336100 336127 Vulcanisaeta moutnovskia 768-28, complete genome blastn 28 52.8 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Vulcanisaeta Vulcanisaeta moutnovskia
25482649 25482649 PRJNA939369_S_NODE_4980_length_543_cov_2.627660_g4564_i0 PRJNA939369 4980 543 2.62766 14.2681938 Nitrosopumilus 338191 Archaea Archaea 726 0   NTclustered gi|756791811|gb|CP010868.1| 1582439 g4564 i0 90.826 34.2338858195212 545 46 100 4 1 543 1691497 1692039 Nitrosopumilus piranensis strain D3C chromosome, complete genome blastn 18589 732 0.991803278688525 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus piranensis
25482658 25482658 PRJNA939369_S_NODE_54340_length_251_cov_1.297753_g53923_i0 PRJNA939369 54340 251 1.297753 3.25736003 Methanobrevibacter 2172 Archaea Archaea 411 3.2599999999999996e-110   NTclustered gi|2791693311|gb|CP144200.1| 2173 g53923 i0 96.414 109.593625498008 251 5 100 2 1 251 1282484 1282730 Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome blastn 27508 411 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter smithii

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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