RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA489308 · 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
1724847 1724847 PRJNA489308_P_NODE_18662_length_293_cov_1.395455_g18586_i0 PRJNA489308 18662 293 1.395455 4.08868315 Oscarella lobularis 121494 Porifera other_Eukaryota 52.8 0.027   NTclustered gi|2746776794|ref|XM_065972286.1| 121494 g18586 i0 100 0.0955631399317406 28 0 10 0 96 123 1019 1046 PREDICTED: Oscarella lobularis condensin complex subunit 2-like (LOC136185209), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
3001032 3001032 PRJNA489308_P_NODE_37863_length_242_cov_0.911243_g37787_i0 PRJNA489308 37863 242 0.911243 2.20520806 Halichondria panicea 6063 Porifera other_Eukaryota 75 4.65e-9   NTclustered gi|2719056366|ref|XM_064536177.1| 6063 g37787 i0 94 1.72314049586777 50 1 20 2 157 205 1166 1118 PREDICTED: Halichondria panicea putative phospholipase B-like 2 (LOC135339930), mRNA blastn 417 75 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
23402596 23402596 PRJNA489308_P_NODE_6679_length_415_cov_1.769006_g6603_i0 PRJNA489308 6679 415 1.769006 7.3413749 Sycon ciliatum 27933 Porifera other_Eukaryota 276 2.18e-69   NTclustered gi|457866940|emb|HF570264.1| 27933 g6603 i0 84.397 70.0120481927711 282 42 68 2 135 415 418 138 Sycon ciliatum mRNA for 40S ribosomal protein S23 (rps23 gene) blastn 29055 276 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);;