RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA615351 · 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
3146506 3146506 PRJNA615351_P_NODE_183503_length_153_cov_1.355932_g169403_i0 PRJNA615351 183503 153 1.355932 2.07457596 Perkinsus marinus 31276 SAR_Eukaryotes SAR_Eukaryotes 165 1.54e-36   NTclustered gi|294950766|ref|XM_002786717.1| 423536 g169403 i0 86.275 14 153 19 99 2 2 153 234 385 Perkinsus marinus ATCC 50983 40S ribosomal protein S14, putative, mRNA blastn 2142 165 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus
3146672 3146672 PRJNA615351_P_NODE_52323_length_694_cov_2.449165_g39916_i0 PRJNA615351 52323 694 2.449165 16.9972051 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.019   NTclustered gi|347516619|gb|HQ339917.1| 32597 g39916 i0 100 0.0417867435158501 29 0 4 0 387 415 420 392 Perkinsus olseni strain ALG1 calmodulin gene, partial cds blastn 29 54.7 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
8802850 8802850 PRJNA615351_P_NODE_163287_length_173_cov_0.956522_g149187_i0 PRJNA615351 163287 173 0.956522 1.65478306 root 1 Root_unresolved Root_unresolved 99 1.84e-16   NTclustered gi|294893753|ref|XM_002774584.1| 423536 g149187 i0 83.178 44.6589595375723 107 18 62 0 12 118 1334 1228 Perkinsus marinus ATCC 50983 heat shock protein 70, putative, mRNA blastn 7726 99 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus
19722484 19722484 PRJNA615351_P_NODE_56536_length_638_cov_2.529022_g39916_i1 PRJNA615351 56536 638 2.529022 16.13516036 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.018   NTclustered gi|347516619|gb|HQ339917.1| 32597 g39916 i1 100 0.0454545454545455 29 0 5 0 224 252 392 420 Perkinsus olseni strain ALG1 calmodulin gene, partial cds blastn 29 54.7 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni

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