RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "blastn", bioproject = "PRJNA864829" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 24 ✖

tax_kingdom 1

bioproject 1

  • PRJNA864829 · 24 ✖

analysis 1

  • blastn · 24 ✖

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
847285 847285 PRJNA864829_S_NODE_5101_length_262_cov_1.690141_g5015_i0 PRJNA864829 5101 262 1.690141 4.42816942 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 438 1.5699999999999999e-118   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g5015 i0 100 21.0954198473282 237 0 90 0 26 262 1790109 1790345 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 5527 438 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
2122669 2122669 PRJNA864829_S_NODE_6442_length_240_cov_1.403141_g6356_i0 PRJNA864829 6442 240 1.403141 3.3675384 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 422 1.4299999999999998e-113   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g6356 i0 98.333 61.325 240 4 100 0 1 240 293145 292906 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 14718 422 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
2122679 2122679 PRJNA864829_S_NODE_8442_length_214_cov_2.242424_g8356_i0 PRJNA864829 8442 214 2.242424 4.79878736 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 165 2.32e-36   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g8356 i0 80.909 1.02803738317757 220 33 100 5 1 214 1533797 1534013 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 220 165 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
2512396 2512396 PRJNA864829_S_NODE_7522_length_225_cov_1.011364_g7436_i0 PRJNA864829 7522 225 1.011364 2.275569 Candidatus Nitrosocosmicus 1826864 Archaea Archaea 361 2.9299999999999993e-95   NTclustered gi|937513727|gb|CP012850.1| 1353260 g7436 i0 100 65.3866666666667 195 0 87 0 25 219 850379 850573 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 14712 361 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
3398021 3398021 PRJNA864829_S_NODE_3_length_2285_cov_10.428444_g2_i0 PRJNA864829 3 2285 10.428444 238.2899454 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 3596 0   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g2 i0 99.594 73.5619256017505 1971 8 99 0 315 2285 290827 292797 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 168089 3596 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
4675692 4675692 PRJNA864829_S_NODE_10984_length_192_cov_0.846154_g10898_i0 PRJNA864829 10984 192 0.846154 1.62461568 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 115 2.08e-21   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g10898 i0 79.651 1.80208333333333 172 25 89 6 23 192 1534648 1534811 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 346 115 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
5950572 5950572 PRJNA864829_S_NODE_1905_length_372_cov_3.040248_g1819_i0 PRJNA864829 1905 372 3.040248 11.30972256 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 390 6.6e-104   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g1819 i0 87.172 0.922043010752688 343 44 92 0 30 372 1531448 1531790 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 343 390 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
5950601 5950601 PRJNA864829_S_NODE_7125_length_230_cov_1.856354_g7039_i0 PRJNA864829 7125 230 1.856354 4.2696142 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 331 2.3600000000000002e-86   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g7039 i0 92.641 7.00434782608696 231 15 100 2 1 230 1535062 1534833 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 1611 331 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
8500201 8500201 PRJNA864829_S_NODE_4447_length_276_cov_2.052863_g4361_i0 PRJNA864829 4447 276 2.052863 5.66590188 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 339 1.7399999999999995e-88   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g4361 i0 90.038 0.945652173913043 261 26 95 0 1 261 248719 248979 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 261 339 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
11051008 11051008 PRJNA864829_S_NODE_1909_length_372_cov_2.108359_g1823_i0 PRJNA864829 1909 372 2.108359 7.84309548 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 643 4.589999999999999e-180   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g1823 i0 97.849 9.15591397849462 372 8 100 0 1 372 1535559 1535188 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 3406 643 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
11051031 11051031 PRJNA864829_S_NODE_5269_length_259_cov_1.028571_g5183_i0 PRJNA864829 5269 259 1.028571 2.66399889 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 185 2.2299999999999993e-42   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g5183 i0 81.938 0.876447876447876 227 33 86 7 32 254 1532843 1533065 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 227 185 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
12326438 12326438 PRJNA864829_S_NODE_5470_length_255_cov_1.606796_g5384_i0 PRJNA864829 5470 255 1.606796 4.0973298 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 372 1.57e-98   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g5384 i0 92.941 4.30980392156863 255 18 100 0 1 255 83240 83494 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 1099 372 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
12326451 12326451 PRJNA864829_S_NODE_830_length_514_cov_3.578495_g745_i0 PRJNA864829 830 514 3.578495 18.3934643 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 900 0   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g745 i0 99.594 96.6459143968872 493 2 96 0 1 493 1789851 1789359 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 49676 900 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
13600953 13600953 PRJNA864829_S_NODE_15511_length_166_cov_0.923077_g15425_i0 PRJNA864829 15511 166 0.923077 1.53230782 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 202 1.2999999999999998e-47   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g15425 i0 90.26 0.927710843373494 154 15 93 0 13 166 215909 215756 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 154 202 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
13600978 13600978 PRJNA864829_S_NODE_4051_length_285_cov_2.351695_g3965_i0 PRJNA864829 4051 285 2.351695 6.70233075 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 383 8.22e-102   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g3965 i0 90.909 1.00350877192982 286 25 100 1 1 285 1390989 1391274 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 286 383 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
13601005 13601005 PRJNA864829_S_NODE_9051_length_208_cov_1.572327_g8965_i0 PRJNA864829 9051 208 1.572327 3.27044016 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 281 2.13e-71   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g8965 i0 95.455 12.8557692307692 176 8 85 0 8 183 1530503 1530328 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 2674 281 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
13990754 13990754 PRJNA864829_S_NODE_4131_length_283_cov_2.410256_g4045_i0 PRJNA864829 4131 283 2.410256 6.82102448 Candidatus Nitrosotenuis 1825023 Archaea Archaea 521 1.6599999999999996e-143   NTclustered gi|808354332|gb|CP011097.2| 1603555 g4045 i0 100 96.1413427561837 282 0 99 0 2 283 741185 740904 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 27208 521 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
14875330 14875330 PRJNA864829_S_NODE_9772_length_201_cov_1.822368_g9686_i0 PRJNA864829 9772 201 1.822368 3.66295968 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 331 2.01e-86   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g9686 i0 100 20.2786069651741 179 0 89 0 1 179 1790056 1789878 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 4076 331 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
16149991 16149991 PRJNA864829_S_NODE_6973_length_232_cov_2.125683_g6887_i0 PRJNA864829 6973 232 2.125683 4.93158456 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 228 3.209999999999999e-55   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g6887 i0 86.765 0.879310344827586 204 27 88 0 3 206 1532705 1532502 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 204 228 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
18698644 18698644 PRJNA864829_S_NODE_8475_length_214_cov_1.484848_g8389_i0 PRJNA864829 8475 214 1.484848 3.17757472 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 351 1.66e-92   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g8389 i0 100 28.6775700934579 190 0 89 0 25 214 1791426 1791615 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 6137 351 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
19973879 19973879 PRJNA864829_S_NODE_15976_length_163_cov_3.017544_g15890_i0 PRJNA864829 15976 163 3.017544 4.91859672 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 122 1.0199999999999999e-23   NTclustered gi|808354332|gb|CP011097.2| 1603555 g15890 i0 90.323 0.938650306748466 93 9 57 0 57 149 349511 349603 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 153 122 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
19973892 19973892 PRJNA864829_S_NODE_3496_length_300_cov_2.517928_g3410_i0 PRJNA864829 3496 300 2.517928 7.553784 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 117 9.76e-22   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g3410 i0 82.222 0.45 135 24 45 0 166 300 781379 781245 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 135 117 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
21249459 21249459 PRJNA864829_S_NODE_7117_length_230_cov_2.309392_g7031_i0 PRJNA864829 7117 230 2.309392 5.3116016 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 381 2.309999999999999e-101   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g7031 i0 100 16.1086956521739 206 0 90 0 1 206 1791012 1790807 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 3705 381 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
25073365 25073365 PRJNA864829_S_NODE_1820_length_380_cov_2.737160_g1734_i0 PRJNA864829 1820 380 2.73716 10.401208 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 449 1.0999999999999999e-121   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g1734 i0 94.792 0.994736842105263 288 15 99 0 1 288 1533441 1533154 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 378 449 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius

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