RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA603943" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermoproteati · 5 ✖

bioproject 1

  • PRJNA603943 · 5 ✖

analysis 1

  • diamond · 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
27932819 27932819 PRJNA603943_P_NODE_6625_length_598_cov_1.906667_g6439_i0 PRJNA603943 6625 598 1.906667 11.40186866 Nitrosopumilaceae archaeon 2202732 Archaea Archaea 75.1 4.43e-13   NR HWY36762.1 2202732 g6439 i0 31.9 0.581939799331104 116 78 57.7 1 346 2 7 122 HWY36762.1 hypothetical protein [Nitrosopumilaceae archaeon] diamond 348 75.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae archaeon
28122238 28122238 PRJNA603943_P_NODE_4545_length_702_cov_1.060413_g4366_i0 PRJNA603943 4545 702 1.060413 7.44409926 Nitrosopumilaceae archaeon 2202732 Archaea Archaea 144 1.17e-35   NR HWY36707.1 2202732 g4366 i0 36.4 1.02136752136752 239 133 99.6 7 2 700 411 636 HWY36707.1 hypothetical protein [Nitrosopumilaceae archaeon] diamond 717 144 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae archaeon
28311774 28311774 PRJNA603943_P_NODE_57766_length_248_cov_0.880000_g57574_i0 PRJNA603943 57766 248 0.88 2.1824 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 77 1.25e-14   NR HVD07366.1 2169593 g57574 i0 49.3 0.883064516129032 73 37 88.3 0 29 247 194 266 HVD07366.1 retropepsin-like aspartic protease [Nitrososphaeraceae archaeon] diamond 219 77 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32293346 32293346 PRJNA603943_P_NODE_23619_length_360_cov_1.073171_g23427_i0 PRJNA603943 23619 360 1.073171 3.8634156 Nitrosopumilaceae archaeon 2202732 Archaea Archaea 44.7 0.0148   NR HWY36762.1 2202732 g23427 i0 34.4 1.025 61 40 50.8 0 353 171 112 172 HWY36762.1 hypothetical protein [Nitrosopumilaceae archaeon] diamond 369 44.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae archaeon
32419581 32419581 PRJNA603943_P_NODE_14559_length_434_cov_1.066482_g14367_i0 PRJNA603943 14559 434 1.066482 4.62853188 Nitrosopumilaceae archaeon 2202732 Archaea Archaea 59.7 1.62e-7   NR HWY33386.1 2202732 g14367 i0 32.4 0.705069124423963 102 69 70.5 0 5 310 32 133 HWY33386.1 hypothetical protein [Nitrosopumilaceae archaeon] diamond 306 59.7 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae archaeon

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