RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA893346" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA893346 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
5971539 5971539 PRJNA893346_P_NODE_30485_length_268_cov_2.205128_g29995_i0 PRJNA893346 30485 268 2.205128 5.90974304 Nitrosopumilus maritimus 338192 Archaea Archaea 496 9.429999999999999e-136   NTclustered gi|160338813|gb|CP000866.1| 436308 g29995 i0 100 1.98880597014925 268 0 100 0 1 268 1414030 1414297 Nitrosopumilus maritimus SCM1, complete genome blastn 533 496 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus maritimus
8896167 8896167 PRJNA893346_P_NODE_36867_length_245_cov_2.046512_g36377_i0 PRJNA893346 36867 245 2.046512 5.0139544 root 1 Root_unresolved Root_unresolved 453 5.1900000000000006e-123   NTclustered gi|313674020|gb|HQ340613.1| 29281 g36377 i0 100 100 245 0 100 0 1 245 450 206 Uncultured crenarchaeote clone Sapelo_2 16S ribosomal RNA gene, partial sequence blastn 24500 453 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
16545827 16545827 PRJNA893346_P_NODE_40093_length_240_cov_2.293413_g39603_i0 PRJNA893346 40093 240 2.293413 5.5041912 Nitrosopumilus 338191 Archaea Archaea 444 3.05e-120   NTclustered gi|507148339|ref|NR_103142.1| 338192 g39603 i0 100 60.2208333333333 240 0 100 0 1 240 853 614 Nitrosopumilus maritimus strain SCM1 23S ribosomal RNA gene, complete sequence blastn 14453 444 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus maritimus
23820479 23820479 PRJNA893346_P_NODE_30139_length_271_cov_1.025253_g29649_i0 PRJNA893346 30139 271 1.025253 2.77843563 Natronorubrum daqingense 588898 Archaea Archaea 69.4 2.47e-7   NTclustered gi|1134979927|gb|CP019327.1| 588898 g29649 i0 85.294 0.250922509225092 68 8 25 2 108 174 592885 592951 Natronorubrum daqingense strain JX313, complete sequence blastn 68 69.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Natronorubrum Natronorubrum daqingense

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