RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA763243", tax_clade = "Sar" and tax_phylum = "Perkinsozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Perkinsozoa · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA763243 · 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
3295307 3295307 PRJNA763243_P_NODE_72383_length_209_cov_4.220588_g72037_i0 PRJNA763243 72383 209 4.220588 8.82102892 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 82.4 2.34e-11   NTclustered gi|22417090|gb|AF509333.1| 32597 g72037 i0 94.34 25.3492822966507 53 3 25 0 147 199 4713 4765 Perkinsus atlanticus 5S ribosomal RNA, small subunit ribosomal RNA genes, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 5298 82.4 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
27116161 27116161 PRJNA763243_P_NODE_27022_length_313_cov_9.283333_g26676_i0 PRJNA763243 27022 313 9.283333 29.05683229 Perkinsus marinus ATCC 5 31276 SAR_Eukaryotes SAR_Eukaryotes 146 5.74e-42   NR XP_002778466.1 423536 g26676 i0 69.6 0.977635782747604 102 30 96.8 1 309 7 82 183 XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] diamond 306 146 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus
27315857 27315857 PRJNA763243_P_NODE_9843_length_477_cov_1.641089_g9500_i0 PRJNA763243 9843 477 1.641089 7.82799453 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 162 6.130000000000001e-44   NR KAF4659554.1 330153 g9500 i0 63.5 19.2578616352201 126 46 79.2 0 475 98 425 550 KAF4659554.1 60S ribosomal protein L9 [Perkinsus chesapeaki] diamond 9186 162 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus chesapeaki
29326709 29326709 PRJNA763243_P_NODE_20909_length_347_cov_5.014599_g20563_i0 PRJNA763243 20909 347 5.014599 17.40065853 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 70.5 1.97e-11   NR KAF4689488.1 32597 g20563 i0 35.3 1.42651296829971 85 55 73.5 0 90 344 85 169 KAF4689488.1 hypothetical protein FOZ60_001611 [Perkinsus olseni] diamond 495 70.5 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);;