RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA415856" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 22 ✖

bioproject 1

  • PRJNA415856 · 22 ✖

analysis 1

  • diamond · 22 ✖
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
18270862 18270862 PRJNA415856_P_NODE_23895_length_185_cov_2.397059_g23634_i0 PRJNA415856 23895 185 2.397059 4.43455915 Sulfolobaceae archaeon 2967306 Archaea Archaea 103 6.3799999999999996e-24   NR MEM0173168.1 2967306 g23634 i0 75 0.972972972972973 60 15 97.3 0 2 181 332 391 MEM0173168.1 hypothetical protein [Sulfolobaceae archaeon] diamond 180 103 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae   Sulfolobaceae archaeon
19545251 19545251 PRJNA415856_P_NODE_44476_length_164_cov_0.886957_g44215_i0 PRJNA415856 44476 164 0.886957 1.45460948 Archaea 2157 Archaea Archaea 102 6.649999999999998e-24   NR MBI3638791.1 2026795 g44215 i0 88.9 8.89024390243902 54 6 98.8 0 1 162 57 110 MBI3638791.1 4-hydroxyphenylacetate 3-hydroxylase family protein [Nitrososphaerota archaeon] diamond 1458 102 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
27138355 27138355 PRJNA415856_P_NODE_41482_length_165_cov_0.879310_g41221_i0 PRJNA415856 41482 165 0.87931 1.4508615 Hadesarchaea archaeon CG 2250276 Archaea Archaea 57.8 6.28e-8   NR PIU14093.1 1975561 g41221 i0 50 0.981818181818182 54 27 98.2 0 164 3 100 153 PIU14093.1 MAG: hypothetical protein COT21_01200 [Hadesarchaea archaeon CG08_land_8_20_14_0_20_51_8] diamond 162 57.8 1 Archaea   Methanobacteriati Candidatus Hadarchaeota Candidatus Hadarchaeia       Hadesarchaea archaeon CG08_land_8_20_14_0_20_51_8
27517971 27517971 PRJNA415856_P_NODE_43063_length_164_cov_1.052174_g42802_i0 PRJNA415856 43063 164 1.052174 1.72556536 Halococcus agarilyticus 1232219 Archaea Archaea 105 1.13e-24   NR WP_049902900.1 1232219 g42802 i0 94.3 0.969512195121951 53 3 97 0 1 159 207 259 WP_049902900.1 phosphate ABC transporter permease PstA [Halococcus agarilyticus] diamond 159 105 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus agarilyticus
27739304 27739304 PRJNA415856_P_NODE_21564_length_190_cov_1.219858_g21303_i0 PRJNA415856 21564 190 1.219858 2.3177302 Sulfolobaceae archaeon 2967306 Archaea Archaea 67.4 2.75e-11   NR MEM0174246.1 2967306 g21303 i0 50.8 0.963157894736842 61 30 96.3 0 188 6 110 170 MEM0174246.1 helix-turn-helix domain-containing protein [Sulfolobaceae archaeon] diamond 183 67.4 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae   Sulfolobaceae archaeon
28307305 28307305 PRJNA415856_P_NODE_18306_length_204_cov_0.987097_g18045_i0 PRJNA415856 18306 204 0.987097 2.01367788 Candidatus Aenigmatarchaeota archaeon 3121606 Archaea Archaea 49.7 5.15e-5   NR MBU5575405.1 3121606 g18045 i0 57.9 1.76470588235294 38 16 55.9 0 119 6 5 42 MBU5575405.1 dTMP kinase [Candidatus Aenigmatarchaeota archaeon] diamond 360 49.7 1 Archaea   Nanobdellati Candidatus Aenigmatarchaeota         Candidatus Aenigmatarchaeota archaeon
28433659 28433659 PRJNA415856_P_NODE_42786_length_164_cov_1.591304_g42525_i0 PRJNA415856 42786 164 1.591304 2.60973856 Candidatus Woesearchaeota archaeon 2026803 Archaea Archaea 50.8 1.77e-5   NR MBN2459890.1 2026803 g42525 i0 51 1.86585365853659 51 21 93.3 1 154 2 561 607 MBN2459890.1 VWA domain-containing protein [Candidatus Woesearchaeota archaeon] diamond 306 50.8 1 Archaea   Nanobdellati Candidatus Woesearchaeota         Candidatus Woesearchaeota archaeon
28608091 28608091 PRJNA415856_P_NODE_49447_length_162_cov_0.902655_g49186_i0 PRJNA415856 49447 162 0.902655 1.4623011 Nitrososphaeria 1643678 Archaea Archaea 70.5 6.07e-13   NR RPJ25338.1 2026768 g49186 i0 88.6 1.66666666666667 44 5 81.5 0 31 162 1 44 RPJ25338.1 MAG: hypothetical protein EHM25_13540, partial [Nitrosopumilales archaeon] diamond 270 70.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales     Nitrosopumilales archaeon
28906960 28906960 PRJNA415856_P_NODE_48388_length_162_cov_1.469027_g48127_i0 PRJNA415856 48388 162 1.469027 2.37982374 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 111 4.68e-29   NR HEX2407753.1 2169593 g48127 i0 88.7 9.81481481481481 53 6 98.1 0 2 160 56 108 HEX2407753.1 DDE-type integrase/transposase/recombinase [Nitrososphaeraceae archaeon] diamond 1590 111 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
29538580 29538580 PRJNA415856_P_NODE_24010_length_185_cov_1.500000_g23749_i0 PRJNA415856 24010 185 1.5 2.775 Sulfolobaceae archaeon 2967306 Archaea Archaea 49.3 5.44e-5   NR MEM0173399.1 2967306 g23749 i0 45 0.972972972972973 60 33 97.3 0 180 1 7 66 MEM0173399.1 hypothetical protein [Sulfolobaceae archaeon] diamond 180 49.3 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae   Sulfolobaceae archaeon
29871093 29871093 PRJNA415856_P_NODE_43191_length_164_cov_0.886957_g42930_i0 PRJNA415856 43191 164 0.886957 1.45460948 root 1 Root_unresolved Root_unresolved 45.1 0.00193   NR WP_004029977.1 2162 g42930 i0 44.4 2.72560975609756 45 25 82.3 0 143 9 151 195 WP_004029977.1 HNH endonuclease [Methanobacterium formicicum] diamond 447 45.1 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobacterium Methanobacterium formicicum
29997590 29997590 PRJNA415856_P_NODE_33911_length_168_cov_1.714286_g33650_i0 PRJNA415856 33911 168 1.714286 2.88000048 Methanobrevibacter 2172 Archaea Archaea 97.1 9.82e-22   NR WP_406536942.1 66852 g33650 i0 96.4 14.9464285714286 55 2 98.2 0 1 165 21 75 WP_406536942.1 glycosyltransferase [Methanobrevibacter sp.] diamond 2511 97.8 0.992842535787321 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp.
30043897 30043897 PRJNA415856_P_NODE_28411_length_177_cov_1.507812_g28150_i0 PRJNA415856 28411 177 1.507812 2.66882724 Saliphagus sp. LR7 2282654 Archaea Archaea 79.7 1.12e-15   NR WP_114578608.1 2282654 g28150 i0 71.2 1 59 17 100 0 1 177 164 222 WP_114578608.1 ISH3 family transposase [Saliphagus sp. LR7] diamond 177 79.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Saliphagus Saliphagus sp. LR7
30439936 30439936 PRJNA415856_P_NODE_8993_length_300_cov_1.884462_g8732_i0 PRJNA415856 8993 300 1.884462 5.653386 root 1 Root_unresolved Root_unresolved 85.1 1.87e-17   NR MEK6877666.1 2056631 g8732 i0 75 0.97 48 12 48 0 1 144 220 267 MEK6877666.1 site-specific DNA-methyltransferase [Thermoproteota archaeon] diamond 291 85.9 0.990686845168801 Archaea   Thermoproteati Thermoproteota         Thermoproteota archaeon
30517910 30517910 PRJNA415856_P_NODE_26613_length_180_cov_1.557252_g26352_i0 PRJNA415856 26613 180 1.557252 2.8030536 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 90.5 7.95e-20   NR HJR46673.1 2169593 g26352 i0 78.9 1.9 57 12 95 0 8 178 1 57 HJR46673.1 site-specific integrase [Nitrososphaeraceae archaeon] diamond 342 90.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31813970 31813970 PRJNA415856_P_NODE_27777_length_178_cov_1.558140_g27516_i0 PRJNA415856 27777 178 1.55814 2.7734892 Candidatus Micrarchaeaceae archaeon 2953041 Archaea Archaea 110 6.66e-29   NR MEM3247443.1 2953041 g27516 i0 89.8 0.99438202247191 59 6 99.4 0 178 2 18 76 MEM3247443.1 hypothetical protein [Candidatus Micrarchaeaceae archaeon] diamond 177 110 1 Archaea   Nanobdellati Candidatus Micrarchaeota Candidatus Micrarchaeia Candidatus Micrarchaeales Candidatus Micrarchaeaceae   Candidatus Micrarchaeaceae archaeon
31813978 31813978 PRJNA415856_P_NODE_46477_length_163_cov_0.894737_g46216_i0 PRJNA415856 46477 163 0.894737 1.45842131 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 120 1.45e-33   NR HET6640053.1 2169593 g46216 i0 100 1.95092024539877 53 0 97.5 0 161 3 64 116 HET6640053.1 cbb3-type cytochrome c oxidase subunit I [Nitrososphaeraceae archaeon] diamond 318 120 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31845490 31845490 PRJNA415856_P_NODE_53517_length_161_cov_0.892857_g53256_i0 PRJNA415856 53517 161 0.892857 1.43749977 Marine Group III euryarchaeote 2173149 Archaea Archaea 46.6 5.5e-5   NR HIG63595.1 2173149 g53256 i0 48.1 1.6583850931677 52 27 96.9 0 156 1 6 57 HIG63595.1 hypothetical protein [Marine Group III euryarchaeote] diamond 267 46.6 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Candidatus Thermoprofundales     Marine Group III euryarchaeote
31908887 31908887 PRJNA415856_P_NODE_28457_length_177_cov_1.367188_g28196_i0 PRJNA415856 28457 177 1.367188 2.41992276 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 79.3 2.11e-16   NR HXW12010.1 2169593 g28196 i0 77.6 0.983050847457627 58 13 98.3 0 2 175 42 99 HXW12010.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 174 79.3 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32257283 32257283 PRJNA415856_P_NODE_50138_length_162_cov_0.902655_g49877_i0 PRJNA415856 50138 162 0.902655 1.4623011 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 48.5 2.96e-5   NR MDW0283126.1 2169593 g49877 i0 66.7 1.09259259259259 30 10 55.6 0 2 91 93 122 MDW0283126.1 ArsR family transcriptional regulator [Nitrososphaeraceae archaeon] diamond 177 48.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32446994 32446994 PRJNA415856_P_NODE_11919_length_254_cov_1.068293_g11658_i0 PRJNA415856 11919 254 1.068293 2.71346422 Nitrososphaera sp. 1971748 Archaea Archaea 43.9 0.0163   NR HVX03469.1 1971748 g11658 i0 37.8 0.874015748031496 74 36 87.4 3 27 248 405 468 HVX03469.1 glycosyltransferase family 2 protein [Nitrososphaera sp.] diamond 222 43.9 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
32667663 32667663 PRJNA415856_P_NODE_17940_length_206_cov_0.866242_g17679_i0 PRJNA415856 17940 206 0.866242 1.78445852 Thermoplasmatota archaeon 2806419 Archaea Archaea 42.7 0.0219   NR HEX9710542.1 2806419 g17679 i0 39.4 0.961165048543689 66 39 94.7 1 8 202 136 201 HEX9710542.1 hypothetical protein [Thermoplasmatota archaeon] diamond 198 42.7 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);;