RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1144090 · 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
287889 287889 PRJNA1144090_P_NODE_97221_length_253_cov_3.377778_g96686_i0 PRJNA1144090 97221 253 3.377778 8.54577834 Sycon ciliatum 27933 Porifera other_Eukaryota 76.8 1.36e-9   NTclustered gi|2732891592|ref|XM_065336127.1| 27933 g96686 i0 95.745 2.06324110671937 47 2 19 0 42 88 1629 1583 PREDICTED: Sycon ciliatum cytochrome b5 domain-containing protein 1-like (LOC135823269), mRNA blastn 522 76.8 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
2837622 2837622 PRJNA1144090_P_NODE_103223_length_249_cov_0.875000_g102688_i0 PRJNA1144090 103223 249 0.875 2.17875 Sycon ciliatum 27933 Porifera other_Eukaryota 84.2 7.99e-12   NTclustered gi|2732936045|ref|XM_065335152.1| 27933 g102688 i0 86.076 6.90763052208835 79 9 31 2 90 167 147 224 PREDICTED: Sycon ciliatum methionine aminopeptidase 1-like (LOC135822395), mRNA blastn 1720 84.2 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
21434929 21434929 PRJNA1144090_P_NODE_52797_length_350_cov_3.328520_g52262_i0 PRJNA1144090 52797 350 3.32852 11.64982 Haplosclerida 6049 Porifera other_Eukaryota 119 3.21e-22   NTclustered gi|1284883228|gb|KY825184.1| 178514 g52262 i0 80 8.42571428571429 170 27 48 5 1 167 3309 3474 Amphimedon compressa voucher MNRJ:18771 internal transcribed spacer 2 and 28S ribosomal RNA gene, partial sequence blastn 2949 119 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon compressa
23239610 23239610 PRJNA1144090_P_NODE_34299_length_445_cov_1.655914_g33764_i0 PRJNA1144090 34299 445 1.655914 7.3688173 Corticium candelabrum 121492 Porifera other_Eukaryota 52.8 0.043   NTclustered gi|2664338732|ref|XM_062649089.1| 121492 g33764 i0 100 0.0629213483146067 28 0 6 0 72 99 668 695 PREDICTED: Corticium candelabrum uncharacterized LOC134181820 (LOC134181820), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum

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