RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA966993" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA966993 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
14970086 14970086 PRJNA966993_P_NODE_42992_length_329_cov_1.437500_g42540_i0 PRJNA966993 42992 329 1.4375 4.729375 Amphimedon queenslandica 400682 Porifera other_Eukaryota 52.8 0.031   NTclustered gi|1133483315|ref|XM_020004410.1| 400682 g42540 i0 100 0.340425531914894 28 0 9 0 253 280 2045 2072 PREDICTED: Amphimedon queenslandica OTU domain-containing protein 3-like (LOC109580107), transcript variant X2, mRNA blastn 112 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
16244885 16244885 PRJNA966993_P_NODE_28853_length_394_cov_1.928349_g28401_i0 PRJNA966993 28853 394 1.928349 7.59769506 Suberites domuncula 55567 Porifera other_Eukaryota 62.1 6.26e-5   NTclustered gi|61654747|gb|AY857481.1| 55567 g28401 i0 89.583 0.121827411167513 48 5 12 0 37 84 330 377 Suberites domuncula S24 mRNA, complete cds blastn 48 62.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
17520440 17520440 PRJNA966993_P_NODE_69114_length_271_cov_2.287879_g68662_i0 PRJNA966993 69114 271 2.287879 6.20015209 Oscarella lobularis 121494 Porifera other_Eukaryota 62.1 4.13e-5   NTclustered gi|2746771963|ref|XM_065970474.1| 121494 g68662 i0 89.583 11.4907749077491 48 5 18 0 36 83 563 516 PREDICTED: Oscarella lobularis uncharacterized protein (LOC136183733), transcript variant X2, mRNA blastn 3114 62.1 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
23894920 23894920 PRJNA966993_P_NODE_68639_length_272_cov_1.547739_g68187_i0 PRJNA966993 68639 272 1.547739 4.20985008 Sycon ciliatum 27933 Porifera other_Eukaryota 243 1.38e-59   NTclustered gi|2732934570|ref|XM_065334361.1| 27933 g68187 i0 83.984 18.0477941176471 256 37 93 4 19 272 3384 3131 PREDICTED: Sycon ciliatum clathrin heavy chain 1-like (LOC135821305), mRNA blastn 4909 243 1 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);;