RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA911178" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 16 ✖

bioproject 1

  • PRJNA911178 · 16 ✖

analysis 1

  • blastn · 16 ✖
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
892856 892856 PRJNA911178_P_NODE_294181_length_241_cov_0.916667_g291707_i0 PRJNA911178 294181 241 0.916667 2.20916747 uncultured archaeon 115547 Archaea Archaea 416 6.679999999999999e-112   NTclustered gi|68685412|gb|DQ088782.1| 115547 g291707 i0 99.561 94.0746887966805 228 1 95 0 14 241 48 275 Uncultured archaeon clone MP104-1109-a25 16S ribosomal RNA gene, partial sequence blastn 22672 416 1 Archaea               uncultured archaeon
2168289 2168289 PRJNA911178_P_NODE_294442_length_241_cov_0.916667_g291968_i0 PRJNA911178 294442 241 0.916667 2.20916747 uncultured crenarchaeote 29281 Archaea Archaea 117 7.58e-22   NTclustered gi|82697915|gb|DQ284448.1| 29281 g291968 i0 85 2.05394190871369 120 13 48 5 15 130 740 858 Uncultured crenarchaeote clone MDArch077 putative OB-fold nucleic acid binding protein, putative SpoU-like RNA methylase, and putative conserved protein genes, complete cds blastn 495 117 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
3443379 3443379 PRJNA911178_P_NODE_249603_length_249_cov_1.585227_g247129_i0 PRJNA911178 249603 249 1.585227 3.94721523 uncultured crenarchaeote 29d5 684057 Archaea Archaea 248 2.68e-61   NTclustered gi|262089226|gb|GU059106.1| 684057 g247129 i0 85.477 0.967871485943775 241 31 96 4 10 249 13998 14235 Uncultured crenarchaeote 29d5 genomic sequence blastn 241 248 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote 29d5
4720379 4720379 PRJNA911178_P_NODE_171844_length_288_cov_1.158140_g169371_i0 PRJNA911178 171844 288 1.15814 3.3354432 Halorubrum sp. CBA1229 1853699 Archaea Archaea 462 1.04e-125   NTclustered gi|1861358827|gb|CP054585.1| 1853699 g169371 i0 96.429 8.16666666666667 280 10 97 0 9 288 1483314 1483593 Halorubrum sp. CBA1229 chromosome, complete genome blastn 2352 462 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum sp. CBA1229
4721918 4721918 PRJNA911178_P_NODE_63484_length_440_cov_1.133515_g61031_i0 PRJNA911178 63484 440 1.133515 4.987466 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 747 0   NTclustered gi|937513727|gb|CP012850.1| 1353260 g61031 i0 97.273 29.7772727272727 440 12 100 0 1 440 848350 848789 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 13102 747 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
5996473 5996473 PRJNA911178_P_NODE_52505_length_479_cov_1.312808_g50070_i0 PRJNA911178 52505 479 1.312808 6.28835032 Methanobacterium palustre 2171 Archaea Archaea 800 0   NTclustered gi|584298062|gb|KF882001.1| 2171 g50070 i0 96.875 131.254697286013 480 11 99 2 4 479 599 1078 Methanobacterium palustre strain F 23S ribosomal RNA gene, partial sequence blastn 62871 800 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium palustre
13645533 13645533 PRJNA911178_P_NODE_178431_length_284_cov_1.322275_g175958_i0 PRJNA911178 178431 284 1.322275 3.755261 uncultured crenarchaeote 29281 Archaea Archaea 516 7.74e-142   NTclustered gi|18087452|gb|AF458646.1| 29281 g175958 i0 100 98.2535211267606 279 0 98 0 6 284 149 427 Uncultured crenarchaeote 12_02a 16S ribosomal RNA gene, partial sequence blastn 27904 516 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
14919507 14919507 PRJNA911178_P_NODE_138712_length_315_cov_1.264463_g136239_i0 PRJNA911178 138712 315 1.264463 3.98305845 uncultured archaeon W5-61a 1131008 Archaea Archaea 195 4.63e-45   NTclustered gi|379335420|gb|JQ085825.1| 1131008 g136239 i0 79.125 15.3333333333333 297 50 92 12 25 315 16992 17282 Uncultured archaeon W5-61a genomic sequence blastn 4830 195 1 Archaea               uncultured archaeon W5-61a
15278146 15278146 PRJNA911178_P_NODE_260452_length_247_cov_0.885057_g257978_i0 PRJNA911178 260452 247 0.885057 2.18609079 Archaea 2157 Archaea Archaea 274 4.38e-69   NTclustered gi|2874254077|emb|OY970160.1| 1740634 g257978 i0 86.992 62.7368421052632 246 28 99 4 4 247 6576 6819 MAG: uncultured Nitrososphaerales archaeon isolate MFD09222.bin.1.114 genome assembly, chromosome: 1 blastn 15496 274 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales     uncultured Nitrososphaerales archaeon
15278204 15278204 PRJNA911178_P_NODE_275312_length_244_cov_1.456140_g272838_i0 PRJNA911178 275312 244 1.45614 3.5529816 Methanomada group 2283794 Archaea Archaea 113 9.95e-21   NTclustered gi|2891700162|gb|CP178165.1| 213231 g272838 i0 89.773 39.3688524590164 88 9 36 0 5 92 710149 710236 Methanocaldococcus indicus strain SL43 chromosome, complete genome blastn 9606 113 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanococci Methanococcales Methanocaldococcaceae Methanocaldococcus Methanocaldococcus indicus
16194630 16194630 PRJNA911178_P_NODE_167693_length_290_cov_1.746544_g165220_i0 PRJNA911178 167693 290 1.746544 5.0649776 uncultured crenarchaeote 29d5 684057 Archaea Archaea 313 1.12e-80   NTclustered gi|262089226|gb|GU059106.1| 684057 g165220 i0 86.572 1.9586206896551701 283 38 98 0 6 288 13106 12824 Uncultured crenarchaeote 29d5 genomic sequence blastn 568 313 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote 29d5
17827903 17827903 PRJNA911178_P_NODE_304654_length_227_cov_3.071429_g302180_i0 PRJNA911178 304654 227 3.071429 6.97214383 Methanobacterium 2160 Archaea Archaea 353 4.95e-93   NTclustered gi|110180147|gb|DQ649333.1| 2171 g302180 i0 96.729 112.42731277533 214 3 93 2 1 210 214 1 Methanobacterium palustre strain 21 16S ribosomal RNA gene, partial sequence blastn 25521 353 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium palustre
21294304 21294304 PRJNA911178_P_NODE_231397_length_255_cov_1.653846_g228923_i0 PRJNA911178 231397 255 1.653846 4.2173073 Halorussus gelatinilyticus 2937524 Archaea Archaea 78.7 3.82e-10   NTclustered gi|2234308622|gb|CP096658.1| 2937524 g228923 i0 88.06 0.262745098039216 67 6 26 2 177 242 2188778 2188843 Halorussus gelatinilyticus strain XZYJT40 chromosome, complete genome blastn 67 78.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haladaptataceae Halorussus Halorussus gelatinilyticus
23844350 23844350 PRJNA911178_P_NODE_201679_length_271_cov_1.166667_g199205_i0 PRJNA911178 201679 271 1.166667 3.16166757 uncultured archaeon 115547 Archaea Archaea 492 1.24e-134   NTclustered gi|406717949|emb|HE603053.1| 115547 g199205 i0 99.262 95.7269372693727 271 2 100 0 1 271 443 173 Uncultured archaeon partial 16S rRNA gene, clone Arch56 blastn 25942 492 1 Archaea               uncultured archaeon
23844881 23844881 PRJNA911178_P_NODE_264639_length_246_cov_1.578035_g262165_i0 PRJNA911178 264639 246 1.578035 3.8819661 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 237 5.72e-58   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g262165 i0 84.711 30.150406504065 242 32 98 3 6 245 1790766 1791004 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 7417 237 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
25118160 25118160 PRJNA911178_P_NODE_196920_length_273_cov_2.195000_g194447_i0 PRJNA911178 196920 273 2.195 5.99235 Acidianus sulfidivorans 312539 Archaea Archaea 54.7 0.007   NTclustered gi|1820310478|gb|CP029288.2| 619593 g194447 i0 100 0.106227106227106 29 0 11 0 218 246 2073007 2072979 Acidianus sulfidivorans JP7 chromosome, complete genome blastn 29 54.7 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Acidianus Acidianus sulfidivorans

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