RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJEB64798", tax_kingdom = "Methanobacteriati" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 20 ✖

tax_kingdom 1

  • Methanobacteriati · 20 ✖

bioproject 1

  • PRJEB64798 · 20 ✖

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
128301 128301 PRJEB64798_P_NODE_236521_length_156_cov_5.971963_g234755_i0 PRJEB64798 236521 156 5.971963 9.31626228 Thermoplasmata archaeon 1906666 Archaea Archaea 139 9.59e-29   NTclustered gi|2108430933|gb|CP070629.1| 1906666 g234755 i0 88.696 232.410256410256 115 11 73 2 39 152 286833 286946 MAG: Thermoplasmata archaeon isolate bin983 chromosome blastn 36256 139 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
6507560 6507560 PRJEB64798_P_NODE_63466_length_244_cov_4.276923_g61701_i0 PRJEB64798 63466 244 4.276923 10.43569212 Candidatus Methanomassiliicoccus intestinalis 1406512 Archaea Archaea 80.5 1.01e-10   NTclustered gi|1721134172|emb|LR698974.1| 1406512 g61701 i0 81.915 0.385245901639344 94 17 39 0 80 173 1457425 1457518 Candidatus Methanomassiliicoccus intestinalis isolate MGYG-HGUT-02160 genome assembly, chromosome: 1 blastn 94 80.5 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae Methanomassiliicoccus Candidatus Methanomassiliicoccus intestinalis
7780120 7780120 PRJEB64798_P_NODE_189127_length_170_cov_18.305785_g187361_i0 PRJEB64798 189127 170 18.305785 31.1198345 Cuniculiplasma divulgatum 1673428 Archaea Archaea 62.1 2.36e-5   NTclustered gi|2573965583|gb|CP133595.1| 1673428 g187361 i0 88.462 7.9 52 4 31 2 78 129 1045094 1045045 MAG: Cuniculiplasma divulgatum isolate BR_06 chromosome, complete genome blastn 1343 62.1 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales Cuniculiplasmataceae Cuniculiplasma Cuniculiplasma divulgatum
20527920 20527920 PRJEB64798_P_NODE_141797_length_192_cov_8.636364_g140031_i0 PRJEB64798 141797 192 8.636364 16.58181888 Methanomassiliicoccaceae archaeon DOK 1535962 Archaea Archaea 283 5.39e-72   NTclustered gi|1799215713|gb|CP047880.1| 1535962 g140031 i0 93.229 13.578125 192 13 100 0 1 192 1502999 1502808 Methanomassiliicoccaceae archaeon DOK chromosome, complete genome blastn 2607 283 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae   Methanomassiliicoccaceae archaeon DOK
22670499 22670499 PRJEB64798_P_NODE_54758_length_264_cov_2.893023_g52993_i0 PRJEB64798 54758 264 2.893023 7.63758072 Methanobacteriati 3366610 Archaea Archaea 54.7 0.007   NTclustered gi|193084194|gb|EU686634.1| 526664 g52993 i0 100 0.21969696969697 29 0 11 0 236 264 5603 5631 Uncultured marine group II euryarchaeote KM3-136-D10 genomic sequence blastn 58 54.7 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     uncultured marine group II euryarchaeote KM3-136-D10
26685591 26685591 PRJEB64798_P_NODE_87841_length_212_cov_10.564417_g86075_i0 PRJEB64798 87841 212 10.564417 22.39656404 Methanomassiliicoccales archaeon 1906667 Archaea Archaea 56.2 3.55e-7   NR MFA5313688.1 1906667 g86075 i0 66.7 0.424528301886792 30 10 42.5 0 208 119 175 204 MFA5313688.1 DNA adenine methylase [Methanomassiliicoccales archaeon] diamond 90 56.2 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales     Methanomassiliicoccales archaeon
27570833 27570833 PRJEB64798_P_NODE_184404_length_172_cov_9.252033_g182638_i0 PRJEB64798 184404 172 9.252033 15.91349676 Thermoplasmatales archaeon 2268204 Archaea Archaea 42.4 0.0194   NR UCD14644.1 2268204 g182638 i0 50 0.697674418604651 40 20 69.8 0 137 18 13 52 UCD14644.1 MAG: right-handed parallel beta-helix repeat-containing protein [Thermoplasmatales archaeon] diamond 120 42.4 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales     Thermoplasmatales archaeon
27570871 27570871 PRJEB64798_P_NODE_219684_length_162_cov_3.238938_g217918_i0 PRJEB64798 219684 162 3.238938 5.24707956 Marine Group III euryarchaeote 2173149 Archaea Archaea 54.7 7.44e-7   NR MDC0161484.1 2173149 g217918 i0 45.8 2.07407407407407 59 26 98.1 1 2 160 352 410 MDC0161484.1 putative Ig domain-containing protein [Marine Group III euryarchaeote] diamond 336 54.7 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Candidatus Thermoprofundales     Marine Group III euryarchaeote
27595746 27595746 PRJEB64798_P_NODE_97624_length_212_cov_3.607362_g95858_i0 PRJEB64798 97624 212 3.607362 7.64760744 Archaea 2157 Archaea Archaea 57 2.34e-7   NR DAC64442.1 2163009 g95858 i0 67.5 1.13207547169811 40 13 56.6 0 6 125 537 576 DAC64442.1 MAG TPA: hypothetical protein D7I10_00020, partial [Candidatus Poseidoniales archaeon] diamond 240 57 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     Candidatus Poseidoniales archaeon
30002445 30002445 PRJEB64798_P_NODE_82131_length_213_cov_14.140244_g80365_i0 PRJEB64798 82131 213 14.140244 30.11871972 Thermoplasmata archaeon 1906666 Archaea Archaea 57.4 1.71e-7   NR RLF27970.1 1906666 g80365 i0 42.6 6.70422535211268 68 37 95.8 1 205 2 186 251 RLF27970.1 MAG: pyruvate:ferredoxin (flavodoxin) oxidoreductase [Thermoplasmata archaeon] diamond 1428 57.4 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
30248245 30248245 PRJEB64798_P_NODE_166752_length_180_cov_4.000000_g164986_i0 PRJEB64798 166752 180 4 7.2 root 1 Root_unresolved Root_unresolved 60.1 6.99e-9   NR MBE3139027.1 1906666 g164986 i0 46.6 1.93333333333333 58 30 96.7 1 3 176 30 86 MBE3139027.1 hypothetical protein [Thermoplasmata archaeon] diamond 348 60.1 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
30255232 30255232 PRJEB64798_P_NODE_187972_length_171_cov_3.295082_g186206_i0 PRJEB64798 187972 171 3.295082 5.63459022 Thermoplasmata archaeon 1906666 Archaea Archaea 102 3.86e-27   NR MDD4308456.1 1906666 g186206 i0 92.7 1.92982456140351 55 4 96.5 0 165 1 6 60 MDD4308456.1 F0F1 ATP synthase subunit C [Thermoplasmata archaeon] diamond 330 102 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
30823806 30823806 PRJEB64798_P_NODE_91534_length_212_cov_5.865031_g89768_i0 PRJEB64798 91534 212 5.865031 12.43386572 Candidatus Methanomethylophilaceae archaeon 2517205 Archaea Archaea 74.3 1.82e-13   NR MFA7162250.1 2517205 g89768 i0 84.8 0.466981132075472 33 5 46.7 0 112 210 472 504 MFA7162250.1 DNA polymerase [Candidatus Methanomethylophilaceae archaeon] diamond 99 74.3 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae   Candidatus Methanomethylophilaceae archaeon
31322332 31322332 PRJEB64798_P_NODE_52115_length_271_cov_3.666667_g50350_i0 PRJEB64798 52115 271 3.666667 9.93666757 root 1 Root_unresolved Root_unresolved 90.9 2.75e-19   NR MEM4934900.1 1906666 g50350 i0 77.1 2.19188191881919 48 11 53.1 0 6 149 274 321 MEM4934900.1 hypothetical protein [Thermoplasmata archaeon] diamond 594 90.9 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
31638568 31638568 PRJEB64798_P_NODE_174756_length_176_cov_16.393701_g172990_i0 PRJEB64798 174756 176 16.393701 28.85291376 Archaea 2157 Archaea Archaea 71.6 9.77e-13   NR GIQ97660.1 2163009 g172990 i0 66.7 3.88636363636364 57 18 97.2 1 5 175 569 624 GIQ97660.1 MAG: hypothetical protein CM15mP3_06940 [Candidatus Poseidoniales archaeon] diamond 684 71.6 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     Candidatus Poseidoniales archaeon
31638582 31638582 PRJEB64798_P_NODE_240296_length_155_cov_3.235849_g238530_i0 PRJEB64798 240296 155 3.235849 5.01556595 Archaea 2157 Archaea Archaea 42 0.0212   NR WP_188680452.1 399579 g238530 i0 40.8 2.69032258064516 49 29 94.8 0 155 9 232 280 WP_188680452.1 PINc/VapC family ATPase [Thermogymnomonas acidicola] diamond 417 42 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales   Thermogymnomonas Thermogymnomonas acidicola
32335000 32335000 PRJEB64798_P_NODE_251719_length_151_cov_5.156863_g249953_i0 PRJEB64798 251719 151 5.156863 7.78686313 root 1 Root_unresolved Root_unresolved 62 1.68e-9   NR HIC76147.1 2163009 g249953 i0 65.9 9.15894039735099 44 15 87.4 0 5 136 160 203 HIC76147.1 hypothetical protein [Candidatus Poseidoniales archaeon] diamond 1383 62 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     Candidatus Poseidoniales archaeon
32587925 32587925 PRJEB64798_P_NODE_122419_length_204_cov_19.838710_g120653_i0 PRJEB64798 122419 204 19.83871 40.4709684 root 1 Root_unresolved Root_unresolved 47.8 5.88e-5   NR MFA5452740.1 2517205 g120653 i0 60.6 0.941176470588235 33 13 48.5 0 104 6 1 33 MFA5452740.1 hypothetical protein [Candidatus Methanomethylophilaceae archaeon] diamond 192 47.8 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae   Candidatus Methanomethylophilaceae archaeon
32619175 32619175 PRJEB64798_P_NODE_140160_length_193_cov_5.888889_g138394_i0 PRJEB64798 140160 193 5.888889 11.36555577 root 1 Root_unresolved Root_unresolved 63.9 1e-11   NR MEI6797123.1 1906667 g138394 i0 86.5 9.77720207253886 37 5 57.5 0 2 112 27 63 MEI6797123.1 SDR family oxidoreductase [Methanomassiliicoccales archaeon] diamond 1887 63.9 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales     Methanomassiliicoccales archaeon
32815052 32815052 PRJEB64798_P_NODE_35420_length_331_cov_12.730496_g33662_i0 PRJEB64798 35420 331 12.730496 42.13794176 Thermoplasmata archaeon 1906666 Archaea Archaea 46.6 0.00462   NR HYK92917.1 1906666 g33662 i0 33.8 2.40181268882175 71 45 64.4 1 241 29 703 771 HYK92917.1 PKD domain-containing protein [Thermoplasmata archaeon] diamond 795 46.6 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata 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);;