RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA1188114" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 14 ✖

tax_phylum 1

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1188114 · 14 ✖

analysis 1

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
320095 320095 PRJNA1188114_P_NODE_2441_length_274_cov_1.453333_g2389_i0 PRJNA1188114 2441 274 1.453333 3.98213242 archaeon 1906665 Archaea Archaea 113 6.949999999999999e-28   NR RYH13701.1 1906665 g2389 i0 65.6 0.985401459854015 90 31 98.5 0 273 4 200 289 RYH13701.1 MAG: 50S ribosomal protein L4 [archaeon] diamond 270 113 1 Archaea               archaeon
2317445 2317445 PRJNA1188114_P_NODE_3842_length_225_cov_1.448864_g3790_i0 PRJNA1188114 3842 225 1.448864 3.259944 archaeon 1906665 Archaea Archaea 151 9.03e-45   NR RYH12715.1 1906665 g3790 i0 91.9 0.986666666666667 74 6 98.7 0 223 2 34 107 RYH12715.1 MAG: elongation of very long chain fatty acids protein [archaeon] diamond 222 151 1 Archaea               archaeon
4146982 4146982 PRJNA1188114_P_NODE_9364_length_178_cov_1.186047_g9312_i0 PRJNA1188114 9364 178 1.186047 2.11116366 archaeon 1906665 Archaea Archaea 82 4.89e-18   NR RYH30236.1 1906665 g9312 i0 69.4 1.04494382022472 62 15 97.8 1 5 178 45 106 RYH30236.1 MAG: hypothetical protein EON65_05740 [archaeon] diamond 186 82 1 Archaea               archaeon
27514743 27514743 PRJNA1188114_P_NODE_3623_length_231_cov_1.065934_g3571_i0 PRJNA1188114 3623 231 1.065934 2.46230754 archaeon 1906665 Archaea Archaea 89.7 3.57e-21   NR RYG67591.1 1906665 g3571 i0 74.6 0.766233766233766 59 15 76.6 0 178 2 2 60 RYG67591.1 MAG: 50S ribosomal protein L23 [archaeon] diamond 177 89.7 1 Archaea               archaeon
27609518 27609518 PRJNA1188114_P_NODE_16604_length_163_cov_1.385965_g16552_i0 PRJNA1188114 16604 163 1.385965 2.25912295 archaeon 1906665 Archaea Archaea 63.9 1.75e-10   NR RYG58925.1 1906665 g16552 i0 75.7 0.680981595092024 37 9 68.1 0 163 53 185 221 RYG58925.1 MAG: 30S ribosomal protein S2, partial [archaeon] diamond 111 63.9 1 Archaea               archaeon
27861926 27861926 PRJNA1188114_P_NODE_2865_length_256_cov_2.323671_g2813_i0 PRJNA1188114 2865 256 2.323671 5.94859776 archaeon 1906665 Archaea Archaea 46.6 4.71e-4   NR RYY73917.1 1906665 g2813 i0 78.6 0.328125 28 6 32.8 0 183 100 91 118 RYY73917.1 MAG: 50S ribosomal protein P1 [archaeon] diamond 84 46.6 1 Archaea               archaeon
29440440 29440440 PRJNA1188114_P_NODE_12330_length_167_cov_0.864407_g12278_i0 PRJNA1188114 12330 167 0.864407 1.44355969 archaeon 1906665 Archaea Archaea 59.7 4.88e-10   NR RYG66845.1 1906665 g12278 i0 87.1 0.55688622754491 31 4 55.7 0 167 75 21 51 RYG66845.1 MAG: hypothetical protein EON64_08805, partial [archaeon] diamond 93 59.7 1 Archaea               archaeon
29692988 29692988 PRJNA1188114_P_NODE_16210_length_164_cov_0.886957_g16158_i0 PRJNA1188114 16210 164 0.886957 1.45460948 archaeon 1906665 Archaea Archaea 56.6 2.31e-8   NR RYG63904.1 1906665 g16158 i0 93.5 0.567073170731707 31 2 56.7 0 162 70 98 128 RYG63904.1 MAG: hypothetical protein EON64_15030 [archaeon] diamond 93 56.6 1 Archaea               archaeon
29819428 29819428 PRJNA1188114_P_NODE_8751_length_180_cov_2.725191_g8699_i0 PRJNA1188114 8751 180 2.725191 4.9053438 archaeon 1906665 Archaea Archaea 118 2.82e-33   NR RYY77943.1 1906665 g8699 i0 91.5 0.983333333333333 59 5 98.3 0 2 178 17 75 RYY77943.1 MAG: 30S ribosomal protein S17 [archaeon] diamond 177 118 1 Archaea               archaeon
29914577 29914577 PRJNA1188114_P_NODE_3391_length_237_cov_2.159574_g3339_i0 PRJNA1188114 3391 237 2.159574 5.11819038 archaeon 1906665 Archaea Archaea 133 8.31e-37   NR RYH18875.1 1906665 g3339 i0 80.8 0.987341772151899 78 13 98.7 1 2 235 166 241 RYH18875.1 MAG: hypothetical protein EON65_26770 [archaeon] diamond 234 133 1 Archaea               archaeon
30009345 30009345 PRJNA1188114_P_NODE_11971_length_167_cov_1.720339_g11919_i0 PRJNA1188114 11971 167 1.720339 2.87296613 Haladaptatus paucihalophilus 367189 Archaea Archaea 107 5.05e-26   NR WP_073096810.1 367189 g11919 i0 90.9 1.97604790419162 55 5 98.8 0 165 1 287 341 WP_073096810.1 NAD(P)/FAD-dependent oxidoreductase [Haladaptatus paucihalophilus] diamond 330 107 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haladaptataceae Haladaptatus Haladaptatus paucihalophilus
30103808 30103808 PRJNA1188114_P_NODE_14852_length_165_cov_0.879310_g14800_i0 PRJNA1188114 14852 165 0.87931 1.4508615 archaeon 1906665 Archaea Archaea 45.8 7.23e-4   NR NCQ51481.1 1906665 g14800 i0 32.7 0.945454545454545 52 35 94.5 0 8 163 40 91 NCQ51481.1 hypothetical protein [archaeon] diamond 156 45.8 1 Archaea               archaeon
30577637 30577637 PRJNA1188114_P_NODE_4213_length_218_cov_0.905325_g4161_i0 PRJNA1188114 4213 218 0.905325 1.9736085 archaeon 1906665 Archaea Archaea 85.1 1.42e-19   NR RYH04918.1 1906665 g4161 i0 86.3 0.701834862385321 51 7 70.2 0 3 155 47 97 RYH04918.1 MAG: 50S ribosomal protein L24 [archaeon] diamond 153 85.1 1 Archaea               archaeon
32853407 32853407 PRJNA1188114_P_NODE_4200_length_218_cov_1.390533_g4148_i0 PRJNA1188114 4200 218 1.390533 3.03136194 archaeon 1906665 Archaea Archaea 103 1.3600000000000002e-26   NR RYH18874.1 1906665 g4148 i0 70.1 0.922018348623853 67 20 92.2 0 16 216 1 67 RYH18874.1 MAG: hypothetical protein EON65_26765 [archaeon] diamond 201 103 1 Archaea               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);;