RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA630162 · 14 ✖

analysis 1

  • blastn · 14 ✖

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
3152269 3152269 PRJNA630162_P_NODE_102583_length_184_cov_1.511111_g101060_i0 PRJNA630162 102583 184 1.511111 2.78044424 Methanomassiliicoccaceae archaeon DOK 1535962 Archaea Archaea 135 1.51e-27   NTclustered gi|1799215713|gb|CP047880.1| 1535962 g101060 i0 80.22 1.98913043478261 182 35 99 1 1 182 1504132 1504312 Methanomassiliicoccaceae archaeon DOK chromosome, complete genome blastn 366 135 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae   Methanomassiliicoccaceae archaeon DOK
3153276 3153276 PRJNA630162_P_NODE_49283_length_251_cov_2.643564_g47760_i0 PRJNA630162 49283 251 2.643564 6.63534564 Methanomassiliicoccales archaeon 1906667 Archaea Archaea 412 9.06e-111   NTclustered gi|1870051182|gb|CP058896.1| 1906667 g47760 i0 96.761 43.3386454183267 247 8 98 0 4 250 1627594 1627348 MAG: Methanomassiliicoccales archaeon isolate Ch47 chromosome blastn 10878 412 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales     Methanomassiliicoccales archaeon
3153472 3153472 PRJNA630162_P_NODE_69583_length_213_cov_1.067073_g68060_i0 PRJNA630162 69583 213 1.067073 2.27286549 Methanomassiliicoccaceae archaeon DOK 1535962 Archaea Archaea 300 6.06e-77   NTclustered gi|1799215713|gb|CP047880.1| 1535962 g68060 i0 92.381 60.887323943662 210 16 99 0 2 211 1504292 1504501 Methanomassiliicoccaceae archaeon DOK chromosome, complete genome blastn 12969 300 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae   Methanomassiliicoccaceae archaeon DOK
5705121 5705121 PRJNA630162_P_NODE_120065_length_174_cov_2.200000_g118542_i0 PRJNA630162 120065 174 2.2 3.828 uncultured Methanomassiliicoccales archaeon 1235852 Archaea Archaea 198 1.78e-46   NTclustered gi|2874253643|emb|OY968769.1| 1235852 g118542 i0 88.82 1.81034482758621 161 18 93 0 1 161 593262 593422 MAG: uncultured Methanomassiliicoccales archaeon isolate MFD00905.bin.2.112 genome assembly, chromosome: 1 blastn 315 198 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales     uncultured Methanomassiliicoccales archaeon
8255159 8255159 PRJNA630162_P_NODE_19327_length_422_cov_2.144772_g17814_i0 PRJNA630162 19327 422 2.144772 9.05093784 Methanomassiliicoccales archaeon 1906667 Archaea Archaea 477 5.659999999999998e-130   NTclustered gi|1870051182|gb|CP058896.1| 1906667 g17814 i0 87.234 9.88862559241706 423 49 99 5 3 422 1629198 1629618 MAG: Methanomassiliicoccales archaeon isolate Ch47 chromosome blastn 4173 477 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales     Methanomassiliicoccales archaeon
8255255 8255255 PRJNA630162_P_NODE_26567_length_354_cov_1.691803_g25045_i0 PRJNA630162 26567 354 1.691803 5.98898262 Candidatus Methanoplasma termitum 1577791 Archaea Archaea 147 1.4899999999999998e-30   NTclustered gi|731480732|gb|CP010070.1| 1577791 g25045 i0 75.522 47.9152542372881 335 63 91 16 27 349 159952 160279 Candidatus Methanoplasma termitum strain MpT1, complete genome blastn 16962 147 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae Candidatus Methanoplasma Candidatus Methanoplasma termitum
10806736 10806736 PRJNA630162_P_NODE_65709_length_218_cov_1.940828_g64186_i0 PRJNA630162 65709 218 1.940828 4.23100504 Candidatus Methanomethylophilaceae archaeon 2517205 Archaea Archaea 320 4.78e-83   NTclustered gi|2621784586|emb|OY781044.1| 2517205 g64186 i0 94.286 15.7935779816514 210 11 96 1 4 213 993217 993009 MAG: Candidatus Methanomethylophilaceae archaeon isolate 11c15bc4-9f39-4069-9170-00aaf79b19ed genome assembly, chromosome: 1 blastn 3443 320 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae   Candidatus Methanomethylophilaceae archaeon
13356060 13356060 PRJNA630162_P_NODE_158911_length_162_cov_1.884956_g157388_i0 PRJNA630162 158911 162 1.884956 3.05362872 Methanomassiliicoccales archaeon 1906667 Archaea Archaea 244 2.07e-60   NTclustered gi|1870051182|gb|CP058896.1| 1906667 g157388 i0 95.425 59.3950617283951 153 7 94 0 8 160 1627753 1627601 MAG: Methanomassiliicoccales archaeon isolate Ch47 chromosome blastn 9622 244 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales     Methanomassiliicoccales archaeon
15179920 15179920 PRJNA630162_P_NODE_61112_length_226_cov_1.514124_g59589_i0 PRJNA630162 61112 226 1.514124 3.42192024 Archaea 2157 Archaea Archaea 313 8.36e-81   NTclustered gi|2874253643|emb|OY968769.1| 1235852 g59589 i0 92.273 2.29646017699115 220 17 97 0 6 225 593210 592991 MAG: uncultured Methanomassiliicoccales archaeon isolate MFD00905.bin.2.112 genome assembly, chromosome: 1 blastn 519 313 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales     uncultured Methanomassiliicoccales archaeon
17180479 17180479 PRJNA630162_P_NODE_59394_length_229_cov_1.538889_g57871_i0 PRJNA630162 59394 229 1.538889 3.52405581 Methanomassiliicoccales archaeon 1906667 Archaea Archaea 228 3.159999999999999e-55   NTclustered gi|1870051182|gb|CP058896.1| 1906667 g57871 i0 85.714 7.34497816593886 217 29 94 2 1 216 1628026 1628241 MAG: Methanomassiliicoccales archaeon isolate Ch47 chromosome blastn 1682 228 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales     Methanomassiliicoccales archaeon
19002829 19002829 PRJNA630162_P_NODE_25375_length_363_cov_2.216561_g23855_i0 PRJNA630162 25375 363 2.216561 8.04611643 Methanomassiliicoccales 1235850 Archaea Archaea 556 5.99e-154   NTclustered gi|1799215713|gb|CP047880.1| 1535962 g23855 i0 94.693 118.977961432507 358 19 99 0 1 358 1502243 1502600 Methanomassiliicoccaceae archaeon DOK chromosome, complete genome blastn 43189 556 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae   Methanomassiliicoccaceae archaeon DOK
22279164 22279164 PRJNA630162_P_NODE_18978_length_426_cov_3.440318_g17466_i0 PRJNA630162 18978 426 3.440318 14.65575468 Thermoplasmatales archaeon BRNA1 1054217 Archaea Archaea 65.8 5.27e-6   NTclustered gi|472831278|gb|CP002916.1| 1054217 g17466 i0 100 7.5093896713615 35 0 8 0 282 316 366610 366576 Thermoplasmatales archaeon BRNA1, complete genome blastn 3199 65.8 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales     Thermoplasmatales archaeon BRNA1
23555017 23555017 PRJNA630162_P_NODE_56199_length_235_cov_2.198925_g54676_i0 PRJNA630162 56199 235 2.198925 5.16747375 Methanomassiliicoccales archaeon 1906667 Archaea Archaea 329 8.69e-86   NTclustered gi|1870051182|gb|CP058896.1| 1906667 g54676 i0 92.576 101.531914893617 229 17 97 0 2 230 1626896 1627124 MAG: Methanomassiliicoccales archaeon isolate Ch47 chromosome blastn 23860 329 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales     Methanomassiliicoccales archaeon
24829009 24829009 PRJNA630162_P_NODE_88200_length_193_cov_1.888889_g86677_i0 PRJNA630162 88200 193 1.888889 3.64555577 Candidatus Methanomethylophilaceae archaeon 2517205 Archaea Archaea 283 5.42e-72   NTclustered gi|2621784586|emb|OY781044.1| 2517205 g86677 i0 93.684 16.0414507772021 190 10 97 2 2 189 990954 990765 MAG: Candidatus Methanomethylophilaceae archaeon isolate 11c15bc4-9f39-4069-9170-00aaf79b19ed genome assembly, chromosome: 1 blastn 3096 283 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae   Candidatus Methanomethylophilaceae 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);;