RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA493828" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 9 ✖

bioproject 1

  • PRJNA493828 · 9 ✖

analysis 1

  • blastn · 9 ✖

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
474525 474525 PRJNA493828_P_NODE_14321_length_311_cov_2.697479_g13902_i0 PRJNA493828 14321 311 2.697479 8.38915969 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 279 1.22e-70   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g13902 i0 100 0.967845659163987 151 0 97 0 1 151 2245927 2245777 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 301 279 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
3657735 3657735 PRJNA493828_P_NODE_3303_length_588_cov_44.064078_g2952_i0 PRJNA493828 3303 588 44.064078 259.09677864 Thermoproteati 1783275 Archaea Archaea 1081 0   NTclustered gi|82618470|gb|DQ278118.1| 29281 g2952 i0 100 97.9591836734694 585 0 99 0 4 588 1373 789 Uncultured crenarchaeote clone OdenA-100ii 16S ribosomal RNA gene, partial sequence; and 16S-23S ribosomal RNA intergenic spacer, complete sequence blastn 57600 1081 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
8127952 8127952 PRJNA493828_P_NODE_43727_length_227_cov_3.597403_g43308_i0 PRJNA493828 43727 227 3.597403 8.16610481 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 409 1.04e-109   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g43308 i0 99.119 1 227 2 100 0 1 227 2056284 2056058 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 227 409 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
11953704 11953704 PRJNA493828_P_NODE_50_length_2949_cov_48.750695_g30_i0 PRJNA493828 50 2949 48.750695 1437.65799555 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 5435 0   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g30 i0 99.932 86.9593082400814 2949 2 100 0 1 2949 1967898 1970846 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 256443 5435 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
17051971 17051971 PRJNA493828_P_NODE_25094_length_270_cov_2.304569_g24675_i0 PRJNA493828 25094 270 2.304569 6.2223363 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 427 3.5199999999999993e-115   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g24675 i0 95.185 1 270 13 100 0 1 270 2059163 2059432 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 270 427 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
17052234 17052234 PRJNA493828_P_NODE_43794_length_227_cov_2.941558_g43375_i0 PRJNA493828 43794 227 2.941558 6.67733666 Candidatus Nitrosocosmicus arcticus 2035267 Archaea Archaea 316 6.489999999999998e-82   NTclustered gi|1241355791|gb|KX863713.1| 2035267 g43375 i0 93.056 80.6607929515419 216 15 95 0 1 216 313 98 Candidatus Nitrosocosmicus arcticus 23S ribosomal RNA gene, partial sequence blastn 18310 316 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus arcticus
18326157 18326157 PRJNA493828_P_NODE_16015_length_310_cov_2.535865_g15596_i0 PRJNA493828 16015 310 2.535865 7.8611815 Candidatus Nitrososphaera gargensis 497727 Archaea Archaea 84.2 1.03e-11   NTclustered gi|408363220|gb|CP002408.1| 1237085 g15596 i0 96.078 0.82258064516129 51 2 16 0 258 308 2678420 2678370 Candidatus Nitrososphaera gargensis Ga9.2, complete genome blastn 255 84.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Candidatus Nitrososphaera gargensis
19600571 19600571 PRJNA493828_P_NODE_26156_length_267_cov_1.582474_g25737_i0 PRJNA493828 26156 267 1.582474 4.22520558 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 483 7.31e-132   NTclustered gi|808354332|gb|CP011097.2| 1603555 g25737 i0 99.251 1 267 2 100 0 1 267 1353702 1353436 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 267 483 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
19600653 19600653 PRJNA493828_P_NODE_31456_length_252_cov_2.022346_g31037_i0 PRJNA493828 31456 252 2.022346 5.09631192 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 459 1.1499999999999996e-124   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g31037 i0 99.602 0.996031746031746 251 1 99 0 2 252 1853227 1853477 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 251 459 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);;