RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA944406 · 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
8912285 8912285 PRJNA944406_P_NODE_4787_length_598_cov_2.053333_g3852_i0 PRJNA944406 4787 598 2.053333 12.27893134 Tethya 34493 Porifera other_Eukaryota 161 9.419999999999999e-35   NTclustered gi|147931666|gb|AY626300.2| 299121 g3852 i0 92.793 20.8612040133779 111 8 19 0 59 169 2392 2282 Tethya sp. UCMPWC957 28S large subunit ribosomal RNA gene, complete sequence blastn 12475 161 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tethyida Tethyidae Tethya Tethya sp. UCMPWC957
14952330 14952330 PRJNA944406_P_NODE_28272_length_283_cov_4.323810_g27313_i0 PRJNA944406 28272 283 4.32381 12.2363823 Topsentia ophiraphidites 281489 Porifera other_Eukaryota 52.8 0.026   NTclustered gi|164420995|ref|NC_010204.1| 281489 g27313 i0 100 0.0989399293286219 28 0 10 0 118 145 2418 2391 Topsentia ophiraphidites mitochondrion, complete genome blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Topsentia Topsentia ophiraphidites
17502774 17502774 PRJNA944406_P_NODE_42934_length_270_cov_1.223350_g41975_i0 PRJNA944406 42934 270 1.22335 3.303045 Sycon ciliatum 27933 Porifera other_Eukaryota 165 3.05e-36   NTclustered gi|2732892859|ref|XM_065341410.1| 27933 g41975 i0 80.909 88.2148148148148 220 32 80 8 55 269 737 523 PREDICTED: Sycon ciliatum ribonucleoside-diphosphate reductase subunit M2 B-like (LOC135828995), transcript variant X1, mRNA blastn 23818 165 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
22601317 22601317 PRJNA944406_P_NODE_16338_length_319_cov_3.898374_g15379_i0 PRJNA944406 16338 319 3.898374 12.43581306 Corticium candelabrum 121492 Porifera other_Eukaryota 99 3.79e-16   NTclustered gi|2664275743|ref|XM_062644631.1| 121492 g15379 i0 83.81 0.589341692789969 105 16 33 1 215 318 169 273 PREDICTED: Corticium candelabrum casein kinase II subunit alpha-like (LOC134177856), mRNA blastn 188 99 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);;