RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1041773" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1041773 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
6548916 6548916 PRJNA1041773_P_NODE_81166_length_249_cov_3.420455_g80833_i0 PRJNA1041773 81166 249 3.420455 8.51693295 uncultured Poseidoniia archaeon 1697135 Archaea Archaea 460 3.16e-125   NTclustered gi|730903770|gb|KP211856.1| 1697135 g80833 i0 100 5.1004016064257 249 0 100 0 1 249 16842 16594 Uncultured Candidatus Thalassoarchaea euryarchaeote clone MedDCM-OCT2007-C2610 genomic sequence blastn 1270 460 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia       uncultured Poseidoniia archaeon
8661666 8661666 PRJNA1041773_P_NODE_50167_length_302_cov_1.327511_g49834_i0 PRJNA1041773 50167 302 1.327511 4.00908322 Methanobacteriati 3366610 Archaea Archaea 91.6 5.96e-14   NTclustered gi|472831278|gb|CP002916.1| 1054217 g49834 i0 94.915 5.44370860927152 59 2 19 1 178 235 347130 347072 Thermoplasmatales archaeon BRNA1, complete genome blastn 1644 91.6 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales     Thermoplasmatales archaeon BRNA1
11648928 11648928 PRJNA1041773_P_NODE_51050_length_299_cov_13.349558_g50717_i0 PRJNA1041773 51050 299 13.349558 39.91517842 uncultured marine group II euryarchaeote 37F11 133822 Archaea Archaea 457 5.039999999999999e-124   NTclustered gi|9664575|gb|AF268611.1| 133822 g50717 i0 94.576 29.2107023411371 295 16 99 0 5 299 6300 6594 Uncultured marine group II euryarchaeote EBAC37F11, BAC clone 37F11, partial sequence blastn 8734 457 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     uncultured marine group II euryarchaeote 37F11
12924675 12924675 PRJNA1041773_P_NODE_87851_length_246_cov_4.531792_g87518_i0 PRJNA1041773 87851 246 4.531792 11.14820832 uncultured Poseidoniia archaeon 1697135 Archaea Archaea 446 8.719999999999999e-121   NTclustered gi|730903812|gb|KP211889.1| 1697135 g87518 i0 99.59 10.7642276422764 244 1 99 0 3 246 1629 1872 Uncultured Candidatus Thalassoarchaea euryarchaeote clone MedDCM-JUL2012-C134 genomic sequence blastn 2648 446 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia       uncultured Poseidoniia archaeon
15473688 15473688 PRJNA1041773_P_NODE_80573_length_250_cov_0.870056_g80240_i0 PRJNA1041773 80573 250 0.870056 2.17514 uncultured Poseidoniia archaeon 1697135 Archaea Archaea 252 2.08e-62   NTclustered gi|730903779|gb|KP211863.1| 1697135 g80240 i0 85.081 0.992 248 35 98 1 5 250 2297 2050 Uncultured Candidatus Thalassoarchaea euryarchaeote clone MedDCM-OCT2007-C3683 genomic sequence blastn 248 252 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia       uncultured Poseidoniia archaeon
16746946 16746946 PRJNA1041773_P_NODE_20834_length_454_cov_9.404199_g20504_i0 PRJNA1041773 20834 454 9.404199 42.69506346 uncultured marine group II euryarchaeote 37F11 133822 Archaea Archaea 819 0   NTclustered gi|9664575|gb|AF268611.1| 133822 g20504 i0 99.336 10.7753303964758 452 3 99 0 3 454 7538 7989 Uncultured marine group II euryarchaeote EBAC37F11, BAC clone 37F11, partial sequence blastn 4892 819 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales     uncultured marine group II euryarchaeote 37F11

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