RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA415856" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 4 ✖

bioproject 1

  • PRJNA415856 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
11286582 11286582 PRJNA415856_P_NODE_1169_length_910_cov_4.167247_g1003_i0 PRJNA415856 1169 910 4.167247 37.9219477 Nitrososphaera 497726 Archaea Archaea 1123 0   NTclustered gi|300521484|gb|GU797787.1| 497727 g1003 i0 89.207 52.810989010989 908 87 99 10 6 909 921 21 Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence blastn 48058 1123 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Candidatus Nitrososphaera gargensis
13173068 13173068 PRJNA415856_P_NODE_311_length_1522_cov_3.315682_g241_i0 PRJNA415856 311 1522 3.315682 50.46468004 uncultured crenarchaeote 29281 Archaea Archaea 2206 0   NTclustered gi|22797874|emb|AJ496176.1| 29281 g241 i0 92.857 102.687253613666 1526 99 100 8 1 1522 6919 8438 Uncultured crenarchaeote 34 kb genomic fragment blastn 156290 2206 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
21485364 21485364 PRJNA415856_P_NODE_9657_length_287_cov_2.310924_g9396_i0 PRJNA415856 9657 287 2.310924 6.63235188 Nitrososphaera 497726 Archaea Archaea 479 1.0299999999999996e-130   NTclustered gi|300521484|gb|GU797787.1| 497727 g9396 i0 97.5 42.3728222996516 280 7 98 0 6 285 921 642 Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence blastn 12161 479 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Candidatus Nitrososphaera gargensis
25309521 25309521 PRJNA415856_P_NODE_17720_length_207_cov_1.094937_g17459_i0 PRJNA415856 17720 207 1.094937 2.26651959 Nitrososphaera 497726 Archaea Archaea 316 5.819999999999998e-82   NTclustered gi|300521484|gb|GU797787.1| 497727 g17459 i0 94.203 36.0821256038647 207 12 100 0 1 207 1772 1566 Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence blastn 7469 316 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Candidatus Nitrososphaera gargensis

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