RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA316313" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 5 ✖

bioproject 1

  • PRJNA316313 · 5 ✖

analysis 1

  • blastn · 5 ✖

tax_clade 0

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
1068584 1068584 PRJNA316313_P_NODE_490721_length_150_cov_4.309735_g489335_i0 PRJNA316313 490721 150 4.309735 6.4646025 Nitrosopumilus 338191 Archaea Archaea 126 7.1e-25   NTclustered gi|2518550870|emb|OX638319.1| 517606 g489335 i0 93.976 6.55333333333333 83 5 55 0 68 150 597292 597210 MAG: uncultured Candidatus Nitrosopumilus sp. isolate a9bb1b8d-3405-4f78-8bb0-675615731146 genome assembly, chromosome: 1 blastn 983 126 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus uncultured Candidatus Nitrosopumilus sp.
3619039 3619039 PRJNA316313_P_NODE_431103_length_151_cov_4.307018_g429717_i0 PRJNA316313 431103 151 4.307018 6.50359718 Nitrosotalea 1078904 Archaea Archaea 141 2.56e-29   NTclustered gi|1003583480|emb|LN890280.1| 1078905 g429717 i0 100 24.2317880794702 76 0 50 0 76 151 1604040 1604115 Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 blastn 3659 141 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea devaniterrae
11271753 11271753 PRJNA316313_P_NODE_480129_length_150_cov_6.433628_g478743_i0 PRJNA316313 480129 150 6.433628 9.650442 Nitrosotalea 1078904 Archaea Archaea 126 7.1e-25   NTclustered gi|1003583480|emb|LN890280.1| 1078905 g478743 i0 96.104 1.02666666666667 77 3 51 0 74 150 1773878 1773802 Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 blastn 154 126 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea devaniterrae
15690678 15690678 PRJNA316313_P_NODE_448133_length_151_cov_3.675439_g446747_i0 PRJNA316313 448133 151 3.675439 5.54991289 Candidatus Bathyarchaeota archaeon 2026714 Archaea Archaea 52.8 0.012   NTclustered gi|2874254015|emb|OY970340.1| 2026714 g446747 i0 100 0.185430463576159 28 0 19 0 120 147 1269362 1269389 MAG: Candidatus Bathyarchaeota archaeon isolate MFD04492.bin.c.5 genome assembly, chromosome: 1 blastn 28 52.8 1 Archaea   Thermoproteati Candidatus Bathyarchaeota         Candidatus Bathyarchaeota archaeon
16964161 16964161 PRJNA316313_P_NODE_249934_length_187_cov_2.853333_g248548_i0 PRJNA316313 249934 187 2.853333 5.33573271 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 113 7.240000000000001e-21   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g248548 i0 93.421 8.09090909090909 76 5 41 0 1 76 267575 267650 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 1513 113 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2

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