RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA493244" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA493244 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
1100156 1100156 PRJNA493244_P_NODE_769501_length_524_cov_14.155508_g746925_i0 PRJNA493244 769501 524 14.155508 74.17486192 Metazoa 33208 Porifera other_Eukaryota 102 5.03e-17   NTclustered gi|2432606641|gb|OQ341438.1| 1006814 g746925 i0 80.303 1.53053435114504 132 26 25 0 77 208 357 226 Thenea schmidtii voucher PN83 large subunit ribosomal RNA gene, partial sequence blastn 802 102 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Theneidae Thenea Thenea schmidti
13211544 13211544 PRJNA493244_P_NODE_945891_length_431_cov_4.397297_g922863_i0 PRJNA493244 945891 431 4.397297 18.95235007 Aiolochroia crassa 261677 Porifera other_Eukaryota 159 2.38e-34   NTclustered gi|512765256|gb|KC869494.1| 261677 g922863 i0 88.636 28.7308584686775 132 14 30 1 160 290 1337 1206 Aiolochroia crassa voucher P04 28S ribosomal RNA gene, partial sequence blastn 12383 159 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Verongiida Aplysinidae Aiolochroia Aiolochroia crassa
18306674 18306674 PRJNA493244_P_NODE_1155375_length_344_cov_8.208481_g1132251_i0 PRJNA493244 1155375 344 8.208481 28.23717464 Pachastrella ovisternata 1006801 Porifera other_Eukaryota 75 6.94e-9   NTclustered gi|2802839332|emb|OZ181715.1| 1006801 g1132251 i0 97.674 2.68023255813953 43 1 13 0 10 52 1893 1851 Pachastrella ovisternata genome assembly, organelle: mitochondrion blastn 922 75 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Pachastrellidae Pachastrella Pachastrella ovisternata

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