RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJEB64798 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
3543439 3543439 PRJEB64798_P_NODE_151643_length_187_cov_12.811594_g149877_i0 PRJEB64798 151643 187 12.811594 23.95768078 Thermoprotei 183924 Archaea Archaea 82.4 2.04e-11   NTclustered gi|363804978|gb|JN971013.1| 1126828 g149877 i0 91.525 26.3048128342246 59 5 32 0 27 85 1794 1736 Sulfolobales sp. MK5 23S large subunit ribosomal RNA gene, partial sequence blastn 4919 82.4 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales     Sulfolobales sp. MK5
7370618 7370618 PRJEB64798_P_NODE_189546_length_170_cov_7.619835_g187780_i0 PRJEB64798 189546 170 7.619835 12.9537195 root 1 Root_unresolved Root_unresolved 298 1.65e-76   NTclustered gi|373125855|gb|JN567036.1| 29281 g187780 i0 99.39 98.4529411764706 164 1 96 0 7 170 540 703 Uncultured crenarchaeote clone DDOUBD11 16S ribosomal RNA gene, partial sequence blastn 16737 298 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
8645861 8645861 PRJEB64798_P_NODE_124487_length_202_cov_11.882353_g122721_i0 PRJEB64798 124487 202 11.882353 24.00235306 root 1 Root_unresolved Root_unresolved 355 1.2e-93   NTclustered gi|42406208|gb|AY522899.1| 29281 g122721 i0 98.99 98.0445544554455 198 2 98 0 1 198 413 216 Uncultured crenarchaeote clone MAS5 16S ribosomal RNA gene, partial sequence blastn 19805 355 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
9921012 9921012 PRJEB64798_P_NODE_13328_length_547_cov_9.120482_g11684_i0 PRJEB64798 13328 547 9.120482 49.88903654 Thermoproteati 1783275 Archaea Archaea 800 0   NTclustered gi|325984322|gb|JF262219.1| 29281 g11684 i0 100 84.2504570383912 433 0 84 0 4 436 2 434 Uncultured crenarchaeote clone YLA019 16S ribosomal RNA gene, partial sequence blastn 46085 800 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
17978821 17978821 PRJEB64798_P_NODE_161375_length_183_cov_1.276119_g159609_i0 PRJEB64798 161375 183 1.276119 2.33529777 Pyrobaculum aerophilum 13773 Archaea Archaea 339 1.07e-88   NTclustered gi|18308975|gb|AE009441.1| 178306 g159609 i0 100 1 183 0 100 0 1 183 1795947 1796129 Pyrobaculum aerophilum str. IM2, complete genome blastn 183 339 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermoproteales Thermoproteaceae Pyrobaculum Pyrobaculum aerophilum
19253094 19253094 PRJEB64798_P_NODE_177716_length_175_cov_5.055556_g175950_i0 PRJEB64798 177716 175 5.055556 8.847223 uncultured crenarchaeote 29281 Archaea Archaea 322 1.02e-83   NTclustered gi|58334024|emb|AJ876976.1| 29281 g175950 i0 100 98.8742857142857 174 0 99 0 2 175 451 278 Uncultured crenarchaeote partial 16S rRNA gene, clone CSSed-21Arc blastn 17303 322 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
21805102 21805102 PRJEB64798_P_NODE_234918_length_157_cov_2.833333_g233152_i0 PRJEB64798 234918 157 2.833333 4.44833281 Sulfolobus acidocaldarius 2285 Archaea Archaea 58.4 2.78e-4   NTclustered gi|566046648|gb|CP006977.1| 1435377 g233152 i0 92.683 0.261146496815287 41 1 25 2 75 114 575195 575156 Sulfolobus acidocaldarius SUSAZ, complete genome blastn 41 58.4 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus acidocaldarius
24352774 24352774 PRJEB64798_P_NODE_138780_length_194_cov_3.268966_g137014_i0 PRJEB64798 138780 194 3.268966 6.34179404 uncultured crenarchaeote 29281 Archaea Archaea 320 4.16e-83   NTclustered gi|22797874|emb|AJ496176.1| 29281 g137014 i0 96.859 31.2422680412371 191 6 98 0 1 191 7400 7210 Uncultured crenarchaeote 34 kb genomic fragment blastn 6061 320 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote

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