RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA928559" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 15 ✖

bioproject 1

  • PRJNA928559 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
2178078 2178078 PRJNA928559_P_NODE_161082_length_276_cov_2.645320_g159513_i0 PRJNA928559 161082 276 2.64532 7.3010832 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 510 3.48e-140   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g159513 i0 100 23.3840579710145 276 0 100 0 1 276 1792304 1792029 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 6454 510 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
3454597 3454597 PRJNA928559_P_NODE_226243_length_209_cov_5.257353_g224674_i0 PRJNA928559 226243 209 5.257353 10.98786777 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 387 4.42e-103   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g224674 i0 100 46.0956937799043 209 0 100 0 1 209 292481 292689 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 9634 387 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
7280547 7280547 PRJNA928559_P_NODE_144086_length_294_cov_1.963801_g142517_i0 PRJNA928559 144086 294 1.963801 5.77357494 Candidatus Bathyarchaeia archaeon 3045160 Archaea Archaea 222 1.96e-53   NTclustered gi|2791746555|gb|CP166960.1| 3045160 g142517 i0 93.377 5.78231292517007 151 8 51 2 1 151 1645550 1645698 MAG: Candidatus Bathyarchaeia archaeon isolate Bathy6-F28_MillB chromosome blastn 1700 222 1 Archaea   Thermoproteati Candidatus Bathyarchaeota Candidatus Bathyarchaeia       Candidatus Bathyarchaeia archaeon
7281455 7281455 PRJNA928559_P_NODE_206686_length_245_cov_0.953488_g205117_i0 PRJNA928559 206686 245 0.953488 2.3360456 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 147 9.86e-31   NTclustered gi|808354332|gb|CP011097.2| 1603555 g205117 i0 80.412 1.26938775510204 194 36 79 2 2 194 1336309 1336501 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 311 147 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
7281722 7281722 PRJNA928559_P_NODE_224446_length_224_cov_8.205298_g222877_i0 PRJNA928559 224446 224 8.205298 18.37986752 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 414 2.1999999999999996e-111   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g222877 i0 100 91.8035714285714 224 0 100 0 1 224 292994 293217 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 20564 414 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
7282225 7282225 PRJNA928559_P_NODE_54746_length_466_cov_4.305344_g53180_i0 PRJNA928559 54746 466 4.305344 20.06290304 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 856 0   NTclustered gi|1026536793|gb|KX023321.1| 1846278 g53180 i0 99.785 98.6845493562232 466 1 100 0 1 466 892 1357 Candidatus Nitrosotenuis aquarius strain AQ6f 16S ribosomal RNA gene, partial sequence blastn 45987 856 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
8905861 8905861 PRJNA928559_P_NODE_227887_length_197_cov_4.395161_g226318_i0 PRJNA928559 227887 197 4.395161 8.65846717 Candidatus Nitrosocosmicus 1826864 Archaea Archaea 326 9.1e-85   NTclustered gi|1599533355|emb|LR216287.1| 1798806 g226318 i0 96.447 9.51269035532995 197 7 100 0 1 197 1279 1475 Candidatus Nitrosocosmicus franklandus isolate NFRAN1 genome assembly, chromosome: NFRAN blastn 1874 326 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus franklandianus
8906069 8906069 PRJNA928559_P_NODE_95087_length_365_cov_3.308219_g93518_i0 PRJNA928559 95087 365 3.308219 12.07499935 Archaea 2157 Archaea Archaea 603 7.629999999999998e-168   NTclustered gi|71842090|gb|DQ133425.1| 29281 g93518 i0 96.448 99.772602739726 366 12 100 1 1 365 570 935 Uncultured crenarchaeote clone E548AIRAC 16S ribosomal RNA gene, partial sequence blastn 36417 603 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
16555740 16555740 PRJNA928559_P_NODE_89293_length_376_cov_4.372937_g87724_i0 PRJNA928559 89293 376 4.372937 16.44224312 Candidatus Nitrosotenuis 1825023 Archaea Archaea 695 0   NTclustered gi|808354332|gb|CP011097.2| 1603555 g87724 i0 100 99.0718085106383 376 0 100 0 1 376 740477 740852 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 37251 695 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
17480891 17480891 PRJNA928559_P_NODE_161794_length_276_cov_1.113300_g160225_i0 PRJNA928559 161794 276 1.1133 3.072708 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 488 1.6299999999999995e-133   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g160225 i0 98.551 76.445652173913 276 4 100 0 1 276 291124 290849 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 21099 488 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
19104082 19104082 PRJNA928559_P_NODE_114935_length_332_cov_7.200772_g113366_i0 PRJNA928559 114935 332 7.200772 23.90656304 Candidatus Nitrosotenuis 1825023 Archaea Archaea 614 3.1799999999999995e-171   NTclustered gi|808354332|gb|CP011097.2| 1603555 g113366 i0 100 104.009036144578 332 0 100 0 1 332 741324 740993 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 34531 614 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
19104420 19104420 PRJNA928559_P_NODE_219715_length_234_cov_2.776398_g218146_i0 PRJNA928559 219715 234 2.776398 6.49677132 Thermoproteati 1783275 Archaea Archaea 433 6.41e-117   NTclustered gi|82618470|gb|DQ278118.1| 29281 g218146 i0 100 97.542735042735 234 0 100 0 1 234 1140 1373 Uncultured crenarchaeote clone OdenA-100ii 16S ribosomal RNA gene, partial sequence; and 16S-23S ribosomal RNA intergenic spacer, complete sequence blastn 22825 433 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
20030640 20030640 PRJNA928559_P_NODE_4656_length_1378_cov_4.020690_g3873_i0 PRJNA928559 4656 1378 4.02069 55.4051082 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 2451 0   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g3873 i0 98.767 76.5297532656023 1379 16 100 1 1 1378 291125 292503 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 105458 2451 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
23854767 23854767 PRJNA928559_P_NODE_142879_length_295_cov_5.378378_g141310_i0 PRJNA928559 142879 295 5.378378 15.8662151 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 516 8.08e-142   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g141310 i0 97.993 72.1796610169492 299 2 100 1 1 295 293844 293546 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 21293 516 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
25130525 25130525 PRJNA928559_P_NODE_73380_length_412_cov_1.811209_g71811_i0 PRJNA928559 73380 412 1.811209 7.46218108 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 745 0   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g71811 i0 99.272 40.8373786407767 412 3 100 0 1 412 1789633 1790044 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 16825 745 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola

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