RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA716463" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA716463 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
3744342 3744342 PRJNA716463_P_NODE_111263_length_241_cov_4.428571_g110845_i0 PRJNA716463 111263 241 4.428571 10.67285611 Halobacteriales 2235 Archaea Archaea 80.5 9.95e-11   NTclustered gi|2087953847|gb|CP081958.1| 1017351 g110845 i0 84.81 18.2697095435685 79 12 33 0 1 79 2091181 2091259 Halobaculum magnesiiphilum strain NBRC 109044 chromosome, complete genome blastn 4403 80.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halobaculum Halobaculum magnesiiphilum
5021103 5021103 PRJNA716463_P_NODE_21604_length_310_cov_3.430380_g21187_i0 PRJNA716463 21604 310 3.43038 10.634178 root 1 Root_unresolved Root_unresolved 278 4.39e-70   NTclustered gi|27227784|emb|AJ535122.1| 29281 g21187 i0 100 90.6903225806452 150 0 97 0 1 150 842 693 Uncultured crenarchaeote partial 16S rRNA gene, clone Gitt-GR-74 blastn 28114 278 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
11396414 11396414 PRJNA716463_P_NODE_29729_length_310_cov_2.489451_g29312_i0 PRJNA716463 29729 310 2.489451 7.7172981 root 1 Root_unresolved Root_unresolved 568 2.3299999999999995e-157   NTclustered gi|42557759|emb|AJ627422.1| 29281 g29312 i0 99.677 99.8193548387097 310 1 100 0 1 310 39787 40096 Uncultured crenarchaeote genomic fragment 54d9 blastn 30944 573 0.991273996509599 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
12187081 12187081 PRJNA716463_P_NODE_30210_length_310_cov_2.274262_g29793_i0 PRJNA716463 30210 310 2.274262 7.0502122 Halopiger xanaduensis 387343 Archaea Archaea 58.4 6.22e-4   NTclustered gi|335336085|gb|CP002839.1| 797210 g29793 i0 94.737 0.22258064516129 38 1 12 1 259 295 2408386 2408349 Halopiger xanaduensis SH-6, complete genome blastn 69 58.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Halopiger Halopiger xanaduensis
17286718 17286718 PRJNA716463_P_NODE_88634_length_261_cov_3.031915_g88217_i0 PRJNA716463 88634 261 3.031915 7.91329815 uncultured crenarchaeote 29281 Archaea Archaea 444 3.36e-120   NTclustered gi|42557759|emb|AJ627422.1| 29281 g88217 i0 97.318 102.486590038314 261 7 100 0 1 261 42215 42475 Uncultured crenarchaeote genomic fragment 54d9 blastn 26749 444 1 Archaea   Thermoproteati Thermoproteota         uncultured crenarchaeote
18559298 18559298 PRJNA716463_P_NODE_121215_length_226_cov_3.588235_g120797_i0 PRJNA716463 121215 226 3.588235 8.1094111 uncultured marine thaumarchaeote AD1000_100_C06 1455887 Archaea Archaea 418 1.7199999999999998e-112   NTclustered gi|663500052|gb|KF900324.1| 1455887 g120797 i0 100 1 226 0 100 0 1 226 35173 35398 Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence blastn 226 418 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_100_C06

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