RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA431371" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermoproteati · 5 ✖

bioproject 1

  • PRJNA431371 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
27265498 27265498 PRJNA431371_P_NODE_35603_length_242_cov_0.911243_g35530_i0 PRJNA431371 35603 242 0.911243 2.20520806 Thermoprotei archaeon 2250277 Archaea Archaea 44.7 0.00727   NR RLE94755.1 2250277 g35530 i0 38.1 1.47520661157025 63 38 78.1 1 236 48 210 271 RLE94755.1 MAG: ATPase [Thermoprotei archaeon] diamond 357 44.7 1 Archaea   Thermoproteati Thermoproteota Thermoprotei       Thermoprotei archaeon
31118150 31118150 PRJNA431371_P_NODE_24835_length_251_cov_0.865169_g24762_i0 PRJNA431371 24835 251 0.865169 2.17157419 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 86.3 1.55e-17   NR MDW0176924.1 2169593 g24762 i0 82 0.597609561752988 50 9 59.8 0 102 251 107 156 MDW0176924.1 reverse transcriptase family protein [Nitrososphaeraceae archaeon] diamond 150 86.3 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31909076 31909076 PRJNA431371_P_NODE_35477_length_242_cov_0.911243_g35404_i0 PRJNA431371 35477 242 0.911243 2.20520806 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 69.3 1.5e-11   NR MDW0176924.1 2169593 g35404 i0 88.9 0.446280991735537 36 4 44.6 0 237 130 290 325 MDW0176924.1 reverse transcriptase family protein [Nitrososphaeraceae archaeon] diamond 108 69.3 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32383682 32383682 PRJNA431371_P_NODE_16519_length_316_cov_0.950617_g16446_i0 PRJNA431371 16519 316 0.950617 3.00394972 Nitrososphaera sp. 1971748 Archaea Archaea 43.5 0.0422   NR MFL6309816.1 1971748 g16446 i0 33.3 0.768987341772152 81 43 76.9 2 258 16 215 284 MFL6309816.1 lipoyl synthase [Nitrososphaera sp.] diamond 243 43.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
32542128 32542128 PRJNA431371_P_NODE_22919_length_264_cov_1.717277_g22846_i0 PRJNA431371 22919 264 1.717277 4.53361128 Candidatus Nitrosotenuis sp. 2507556 Archaea Archaea 57.4 1.75e-7   NR MEM3172315.1 2507556 g22846 i0 42.9 0.795454545454545 70 37 79.5 1 50 259 48 114 MEM3172315.1 methyltransferase domain-containing protein [Candidatus Nitrosotenuis sp.] diamond 210 57.4 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis sp.

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