RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA724011" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA724011 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
3262269 3262269 PRJNA724011_P_NODE_91983_length_254_cov_1.254144_g90960_i0 PRJNA724011 91983 254 1.254144 3.18552576 Halisarca dujardinii 2583056 Porifera other_Eukaryota 193 1.3e-44   NTclustered gi|2413770082|gb|ON088636.1| 2583056 g90960 i0 80.62 9.82283464566929 258 42 100 7 1 254 1048 795 Halisarca dujardinii Arp2 mRNA, complete cds blastn 2495 193 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Chondrillida Halisarcidae Halisarca Halisarca dujardinii
13464373 13464373 PRJNA724011_P_NODE_38311_length_434_cov_1.191136_g37288_i0 PRJNA724011 38311 434 1.191136 5.16953024 Halichondria panicea 6063 Porifera other_Eukaryota 52.8 0.042   NTclustered gi|2719020737|ref|XM_064544058.1| 6063 g37288 i0 100 0.193548387096774 28 0 6 0 345 372 39 12 PREDICTED: Halichondria panicea soma ferritin-like (LOC135346440), mRNA blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
16012921 16012921 PRJNA724011_P_NODE_111513_length_232_cov_2.075472_g110490_i0 PRJNA724011 111513 232 2.075472 4.81509504 Agelas conifera 295242 Porifera other_Eukaryota 198 2.52e-46   NTclustered gi|512765396|gb|KC869634.1| 295242 g110490 i0 82.819 96.5043103448276 227 33 97 6 3 228 1424 1645 Agelas conifera voucher P36 28S ribosomal RNA gene, partial sequence blastn 22389 198 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Agelasida Agelasidae Agelas Agelas conifera
19837415 19837415 PRJNA724011_P_NODE_20976_length_635_cov_2.284698_g19964_i0 PRJNA724011 20976 635 2.284698 14.5078323 Oscarella lobularis 121494 Porifera other_Eukaryota 65.8 8.1e-6   NTclustered gi|2746778311|ref|XM_065973065.1| 121494 g19964 i0 97.368 2.98425196850394 38 1 6 0 309 346 2926 2963 PREDICTED: Oscarella lobularis regulator of nonsense transcripts 2-like (LOC136185861), transcript variant X1, mRNA blastn 1895 65.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
22388299 22388299 PRJNA724011_P_NODE_81158_length_275_cov_1.237624_g80135_i0 PRJNA724011 81158 275 1.237624 3.403466 Sycon ciliatum 27933 Porifera other_Eukaryota 56.5 0.002   NTclustered gi|2732930935|ref|XM_065332535.1| 27933 g80135 i0 100 0.738181818181818 30 0 11 0 1 30 1215 1186 PREDICTED: Sycon ciliatum SHC-transforming protein 1-like (LOC135819345), transcript variant X1, mRNA blastn 203 56.5 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);;