RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1160211 · 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
10513818 10513818 PRJNA1160211_S_NODE_260289_length_253_cov_9.150000_g259056_i0 PRJNA1160211 260289 253 9.15 23.1495 uncultured Plakinidae sp. 417971 Porifera other_Eukaryota 322 1.58e-83   NTclustered gi|166083713|gb|EF024236.1| 417971 g259056 i0 91.176 29.6284584980237 238 19 93 2 1 236 602 839 Uncultured Plakinidae sp. clone Elev_18S_603 18S ribosomal RNA gene, partial sequence blastn 7496 322 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae   uncultured Plakinidae sp.
13063933 13063933 PRJNA1160211_S_NODE_295331_length_221_cov_4.939189_g294098_i0 PRJNA1160211 295331 221 4.939189 10.91560769 Corticium candelabrum 121492 Porifera other_Eukaryota 52.8 0.02   NTclustered gi|2664319586|ref|XM_062648256.1| 121492 g294098 i0 100 0.506787330316742 28 0 13 0 144 171 2326 2299 PREDICTED: Corticium candelabrum uncharacterized LOC134181057 (LOC134181057), mRNA blastn 112 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
17616360 17616360 PRJNA1160211_S_NODE_246774_length_264_cov_5.738220_g245541_i0 PRJNA1160211 246774 264 5.73822 15.1489008 Poecilosclerida 27925 Porifera other_Eukaryota 187 6.34e-43   NTclustered gi|1937049806|gb|MW291468.1| 1035643 g245541 i0 89.726 56.2083333333333 146 15 55 0 19 164 2190 2045 Tsitsikamma favus voucher TIC2018-003D internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 14839 187 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Poecilosclerida Latrunculiidae Tsitsikamma Tsitsikamma favus
18161268 18161268 PRJNA1160211_S_NODE_194675_length_317_cov_1.577869_g193442_i0 PRJNA1160211 194675 317 1.577869 5.00184473 Ptilocaulis spiculifer 798311 Porifera other_Eukaryota 95.3 4.86e-15   NTclustered gi|512765322|gb|KC869560.1| 798311 g193442 i0 82.203 37.7318611987382 118 14 37 7 133 248 1227 1339 Ptilocaulis spiculifer voucher NCI205 28S ribosomal RNA gene, partial sequence blastn 11961 95.3 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Axinellida Axinellidae Ptilocaulis Ptilocaulis spiculifer

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