RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA565584" and tax_phylum = "Perkinsozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Perkinsozoa · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA565584 · 4 ✖

analysis 1

  • blastn · 4 ✖

tax_kingdom 0

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
4383450 4383450 PRJNA565584_P_NODE_190464_length_246_cov_0.890173_g189312_i0 PRJNA565584 190464 246 0.890173 2.18982558 Perkinsus marinus 31276 SAR_Eukaryotes SAR_Eukaryotes 158 4.58e-34   NTclustered gi|294929719|ref|XM_002779297.1| 423536 g189312 i0 85.526 26.3130081300813 152 20 61 2 3 153 950 800 Perkinsus marinus ATCC 50983 translation elongation factor EF-1, subunit alpha,, putative, mRNA blastn 6473 158 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus
7513188 7513188 PRJNA565584_P_NODE_68546_length_359_cov_1.076923_g67395_i0 PRJNA565584 68546 359 1.076923 3.86615357 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 252 3.1199999999999997e-62   NTclustered gi|294889482|ref|XM_002772789.1| 423536 g67395 i0 79.501 96.0640668523677 361 68 99 6 1 358 367 10 Perkinsus marinus ATCC 50983 alpha-tubulin, putative, mRNA blastn 34487 252 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus
9484941 9484941 PRJNA565584_P_NODE_26628_length_599_cov_2.076046_g25488_i0 PRJNA565584 26628 599 2.076046 12.43551554 Perkinsus marinus 31276 SAR_Eukaryotes SAR_Eukaryotes 372 4.01e-98   NTclustered gi|294889472|ref|XM_002772784.1| 423536 g25488 i0 81.36 16.5943238731219 456 85 76 0 27 482 68 523 Perkinsus marinus ATCC 50983 translation elongation factor EF-1, subunit alpha,, putative, mRNA blastn 9940 372 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus
20959759 20959759 PRJNA565584_P_NODE_76837_length_339_cov_1.240602_g75686_i0 PRJNA565584 76837 339 1.240602 4.20564078 Perkinsus marinus 31276 SAR_Eukaryotes SAR_Eukaryotes 250 1.06e-61   NTclustered gi|294950766|ref|XM_002786717.1| 423536 g75686 i0 84.375 37.1710914454277 256 38 75 2 1 255 207 461 Perkinsus marinus ATCC 50983 40S ribosomal protein S14, putative, mRNA blastn 12601 250 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus

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