RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA986481" 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

  • PRJNA986481 · 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
6076755 6076755 PRJNA986481_P_NODE_3245_length_838_cov_4.609632_g2881_i0 PRJNA986481 3245 838 4.609632 38.62871616 Haliclona sp. BKON-2565 3127636 Porifera other_Eukaryota 200 2.8499999999999994e-46   NTclustered gi|2899163455|gb|PP464275.1| 3127636 g2881 i0 77.384 27.1658711217184 367 64 43 14 274 630 1835 2192 Haliclona sp. BKON-2565 isolate H2565 mitochondrion, complete genome blastn 22765 200 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Chalinidae Haliclona Haliclona sp. BKON-2565
8626692 8626692 PRJNA986481_P_NODE_43267_length_260_cov_0.957346_g42742_i0 PRJNA986481 43267 260 0.957346 2.4890996 Amphimedon queenslandica 400682 Porifera other_Eukaryota 54.7 0.007   NTclustered gi|1133479327|ref|XM_020003091.1| 400682 g42742 i0 100 0.542307692307692 29 0 11 0 229 257 4490 4462 PREDICTED: Amphimedon queenslandica uncharacterized LOC109586864 (LOC109586864), mRNA blastn 141 54.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
25498636 25498636 PRJNA986481_P_NODE_5140_length_698_cov_4.664099_g4707_i0 PRJNA986481 5140 698 4.664099 32.55541102 Metazoa 33208 Porifera other_Eukaryota 326 3.72e-84   NTclustered gi|2732929399|ref|XM_065331779.1| 27933 g4707 i0 82.703 50.39111747851 370 61 53 3 204 571 556 188 PREDICTED: Sycon ciliatum small ribosomal subunit protein uS12 (LOC135818406), mRNA blastn 35173 329 0.990881458966565 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum

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