RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA976345 · 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
9876021 9876021 PRJNA976345_P_NODE_142868_length_169_cov_2.335821_g141260_i0 PRJNA976345 142868 169 2.335821 3.94753749 Corticium candelabrum 121492 Porifera other_Eukaryota 71.3 3.9e-8   NTclustered gi|2664339161|ref|XM_062649144.1| 121492 g141260 i0 88.136 0.698224852071006 59 7 35 0 104 162 3060 3002 PREDICTED: Corticium candelabrum DNA polymerase epsilon catalytic subunit A-like (LOC134181872), transcript variant X2, mRNA blastn 118 71.3 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
9876691 9876691 PRJNA976345_P_NODE_45668_length_257_cov_1.945946_g44060_i0 PRJNA976345 45668 257 1.945946 5.00108122 Dysidea avara 196820 Porifera other_Eukaryota 134 8.12e-27   NTclustered gi|2749546253|ref|XM_066040654.1| 196820 g44060 i0 79.679 1.75486381322957 187 36 72 2 8 193 2968 2783 PREDICTED: Dysidea avara ATP-dependent RNA helicase DHX8-like (LOC136248839), mRNA blastn 451 134 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
9876850 9876850 PRJNA976345_P_NODE_62368_length_226_cov_1.994764_g60760_i0 PRJNA976345 62368 226 1.994764 4.50816664 Amphimedon queenslandica 400682 Porifera other_Eukaryota 56.5 0.002   NTclustered gi|1133476141|ref|XM_020001838.1| 400682 g60760 i0 100 0.132743362831858 30 0 13 0 151 180 2084 2113 PREDICTED: Amphimedon queenslandica uncharacterized LOC109585711 (LOC109585711), mRNA blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
12427273 12427273 PRJNA976345_P_NODE_170090_length_159_cov_1.258065_g168482_i0 PRJNA976345 170090 159 1.258065 2.00032335 Halichondria panicea 6063 Porifera other_Eukaryota 99 1.67e-16   NTclustered gi|2719018657|ref|XM_064543019.1| 6063 g168482 i0 82.051 1 117 19 73 2 44 159 4062 3947 PREDICTED: Halichondria panicea dynein axonemal heavy chain 12-like (LOC135345604), mRNA blastn 159 99 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
17526166 17526166 PRJNA976345_P_NODE_180434_length_155_cov_2.283333_g178826_i0 PRJNA976345 180434 155 2.283333 3.53916615 Amphimedon queenslandica 400682 Porifera other_Eukaryota 65.8 1.64e-6   NTclustered gi|1133473032|ref|XM_003389002.3| 400682 g178826 i0 95.122 0.264516129032258 41 2 26 0 28 68 1459 1419 PREDICTED: Amphimedon queenslandica tyrosine-protein kinase SRK3-like (LOC100640678), mRNA blastn 41 65.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica

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