RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA773247", tax_kingdom = "Methanobacteriati" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 9 ✖

tax_kingdom 1

  • Methanobacteriati · 9 ✖

bioproject 1

  • PRJNA773247 · 9 ✖

analysis 1

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
27315899 27315899 PRJNA773247_P_NODE_16723_length_358_cov_1.726316_g16639_i0 PRJNA773247 16723 358 1.726316 6.18021128 root 1 Root_unresolved Root_unresolved 46.6 0.00264   NR MEK9695784.1 2163009 g16639 i0 38.5 1.24022346368715 52 32 43.6 0 49 204 2 53 MEK9695784.1 hypothetical protein [Candidatus Poseidoniales archaeon] diamond 444 47 0.991489361702128 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     Candidatus Poseidoniales archaeon
28695691 28695691 PRJNA773247_P_NODE_17487_length_348_cov_35.120000_g17403_i0 PRJNA773247 17487 348 35.12 122.2176 Thermoplasmata archaeon 1906666 Archaea Archaea 72 6.6e-12   NR MCK4718607.1 1906666 g17403 i0 51.6 0.53448275862069 62 30 53.4 0 186 1 3 64 MCK4718607.1 phage terminase large subunit [Thermoplasmata archaeon] diamond 186 72 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
28884892 28884892 PRJNA773247_P_NODE_28388_length_260_cov_3.491979_g28304_i0 PRJNA773247 28388 260 3.491979 9.0791454 Thermoplasmatota archaeon 2806419 Archaea Archaea 50.8 6.72e-5   NR MFA5943196.1 2806419 g28304 i0 40.3 0.888461538461538 77 43 86.5 2 2 226 839 914 MFA5943196.1 hypothetical protein [Thermoplasmatota archaeon] diamond 231 50.8 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
29295394 29295394 PRJNA773247_P_NODE_14809_length_387_cov_2.987261_g14725_i0 PRJNA773247 14809 387 2.987261 11.56070007 Thermoplasmatales archaeon 2268204 Archaea Archaea 216 3.83e-68   NR MEM4379678.1 2268204 g14725 i0 75 0.992248062015504 128 32 99.2 0 385 2 10 137 MEM4379678.1 hypothetical protein [Thermoplasmatales archaeon] diamond 384 216 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales     Thermoplasmatales archaeon
29358644 29358644 PRJNA773247_P_NODE_25129_length_279_cov_6.558252_g25045_i0 PRJNA773247 25129 279 6.558252 18.29752308 Thermoplasmata archaeon 1906666 Archaea Archaea 62.8 1.32e-10   NR MCK5548792.1 1906666 g25045 i0 62.2 0.483870967741935 45 16 48.4 1 148 14 4 47 MCK5548792.1 hypothetical protein [Thermoplasmata archaeon] diamond 135 62.8 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
29358653 29358653 PRJNA773247_P_NODE_35749_length_234_cov_2.503106_g35665_i0 PRJNA773247 35749 234 2.503106 5.85726804 Thermoplasmata archaeon 1906666 Archaea Archaea 66.2 6.85e-12   NR MCK4718806.1 1906666 g35665 i0 43.6 1 78 44 100 0 234 1 20 97 MCK4718806.1 hypothetical protein [Thermoplasmata archaeon] diamond 234 66.2 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
29683503 29683503 PRJNA773247_P_NODE_14110_length_399_cov_2.883436_g14026_i0 PRJNA773247 14110 399 2.883436 11.50490964 root 1 Root_unresolved Root_unresolved 52.8 6.03e-5   NR MCK4718606.1 1906666 g14026 i0 35.8 2.02255639097744 95 60 70.7 1 80 361 4 98 MCK4718606.1 DUF1073 domain-containing protein [Thermoplasmata archaeon] diamond 807 53.1 0.994350282485876 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
29990158 29990158 PRJNA773247_P_NODE_19631_length_324_cov_6.661355_g19547_i0 PRJNA773247 19631 324 6.661355 21.5827902 Thermoplasmata archaeon 1906666 Archaea Archaea 74.7 3.85e-14   NR MCI4354553.1 1906666 g19547 i0 61 0.546296296296296 59 22 53.7 1 3 176 112 170 MCI4354553.1 hypothetical protein [Thermoplasmata archaeon] diamond 177 74.7 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
32392884 32392884 PRJNA773247_P_NODE_32039_length_247_cov_0.885057_g31955_i0 PRJNA773247 32039 247 0.885057 2.18609079 Thermoplasmatota archaeon 2806419 Archaea Archaea 45.8 0.00309   NR MEA3558600.1 2806419 g31955 i0 44.3 0.850202429149798 70 33 85 1 247 38 135 198 MEA3558600.1 hypothetical protein [Thermoplasmatota archaeon] diamond 210 45.8 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota 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);;