RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA1195551" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 12 ✖

bioproject 1

  • PRJNA1195551 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
1597236 1597236 PRJNA1195551_S_NODE_5582_length_367_cov_6.220126_g5229_i0 PRJNA1195551 5582 367 6.220126 22.82786242 Perkinsus 28000 SAR_Eukaryotes SAR_Eukaryotes 136 6.209999999999999e-37   NR KAF4656891.1 330153 g5229 i0 77.1 12.1634877384196 83 19 67.8 0 6 254 191 273 KAF4656891.1 hypothetical protein FOL47_008703, partial [Perkinsus chesapeaki] diamond 4464 137 0.992700729927007 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus chesapeaki
9250458 9250458 PRJNA1195551_S_NODE_20928_length_219_cov_2.141176_g20575_i0 PRJNA1195551 20928 219 2.141176 4.68917544 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 97.4 1.09e-22   NR KAL3796718.1 29204 g20575 i0 71.9 121.561643835616 64 18 87.7 0 219 28 198 261 KAL3796718.1 hypothetical protein HJC23_010018 [Cyclotella cryptica] diamond 26622 98.2 0.991853360488798 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
26679763 26679763 PRJNA1195551_S_NODE_14921_length_253_cov_4.720588_g14568_i0 PRJNA1195551 14921 253 4.720588 11.94308764 Symbiodiniaceae 252141 SAR_Eukaryotes SAR_Eukaryotes 85.5 1.45e-19   NR CAE7595067.1 1519616 g14568 i0 59 11.098814229249 78 29 92.5 1 250 17 13 87 CAE7595067.1 RPL31 [Symbiodinium sp. CCMP2456] diamond 2808 85.5 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium sp. CCMP2456
26977530 26977530 PRJNA1195551_S_NODE_38742_length_165_cov_2.241379_g38389_i0 PRJNA1195551 38742 165 2.241379 3.69827535 Pelagophyceae sp. CCMP2 1982007 SAR_Eukaryotes SAR_Eukaryotes 82 1.84e-16   NR KAJ1456784.1 483370 g38389 i0 73.6 1.89090909090909 53 14 96.4 0 165 7 456 508 KAJ1456784.1 Aldehyde/histidinol dehydrogenase [Pelagophyceae sp. CCMP2097] diamond 312 82 1 Eukaryota Sar     Pelagophyceae       Pelagophyceae sp. CCMP2097
27609618 27609618 PRJNA1195551_S_NODE_24504_length_204_cov_1.006452_g24151_i0 PRJNA1195551 24504 204 1.006452 2.05316208 Blastocystis sp. subtype 4 944170 SAR_Eukaryotes SAR_Eukaryotes 42 0.0414   NR XP_014525269.1 944170 g24151 i0 38.3 0.691176470588235 47 29 69.1 0 44 184 365 411 XP_014525269.1 hypothetical protein JH06_4687 [Blastocystis sp. subtype 4] diamond 141 42 1 Eukaryota Sar     Bigyra Opalinata Blastocystidae Blastocystis Blastocystis sp. subtype 4
27767630 27767630 PRJNA1195551_S_NODE_6064_length_354_cov_5.016393_g5711_i0 PRJNA1195551 6064 354 5.016393 17.75803122 Pelagophyceae sp. CCMP2 1982007 SAR_Eukaryotes SAR_Eukaryotes 108 8.5e-25   NR KAJ1462677.1 483370 g5711 i0 53.5 0.728813559322034 86 40 72.9 0 350 93 458 543 KAJ1462677.1 peptidase S8/S53 domain-containing protein [Pelagophyceae sp. CCMP2097] diamond 258 108 1 Eukaryota Sar     Pelagophyceae       Pelagophyceae sp. CCMP2097
27862031 27862031 PRJNA1195551_S_NODE_37685_length_167_cov_1.322034_g37332_i0 PRJNA1195551 37685 167 1.322034 2.20779678 Eimeria acervulina 5801 SAR_Eukaryotes SAR_Eukaryotes 60.8 4.71e-9   NR XP_013246568.1 5801 g37332 i0 54.7 1.90419161676647 53 24 95.2 0 7 165 255 307 XP_013246568.1 prohibitin, putative [Eimeria acervulina] diamond 318 60.8 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Eimeria Eimeria acervulina
28398903 28398903 PRJNA1195551_S_NODE_37666_length_167_cov_1.533898_g37313_i0 PRJNA1195551 37666 167 1.533898 2.56160966 Globisporangium splendens 82926 SAR_Eukaryotes SAR_Eukaryotes 42 0.0255   NR KAF1331135.1 82926 g37313 i0 39.6 0.952095808383233 53 31 93.4 1 166 11 151 203 KAF1331135.1 hypothetical protein FI667_g4463, partial [Globisporangium splendens] diamond 159 42 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium Globisporangium splendens
28481028 28481028 PRJNA1195551_S_NODE_29086_length_188_cov_1.496403_g28733_i0 PRJNA1195551 29086 188 1.496403 2.81323764 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 47.8 4.01e-5   NR KAJ8556926.1 4785 g28733 i0 45.9 4.86702127659574 61 27 97.3 1 184 2 21 75 KAJ8556926.1 hypothetical protein ON010_g9042 [Phytophthora cinnamomi] diamond 915 47.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
30262295 30262295 PRJNA1195551_S_NODE_37812_length_167_cov_0.881356_g37459_i0 PRJNA1195551 37812 167 0.881356 1.47186452 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 56.6 1.66e-7   NR XP_001016313.1 312017 g37459 i0 42.9 1.0059880239521 56 31 98.8 1 166 2 316 371 XP_001016313.1 eukaryotic aspartyl protease [Tetrahymena thermophila SB210] diamond 168 56.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31260536 31260536 PRJNA1195551_S_NODE_17455_length_237_cov_3.808511_g17102_i0 PRJNA1195551 17455 237 3.808511 9.02617107 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 112 1.41e-27   NR CAJ1937478.1 2856 g17102 i0 69.7 1.92405063291139 76 23 96.2 0 9 236 246 321 CAJ1937478.1 unnamed protein product [Cylindrotheca closterium] diamond 456 112 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31893051 31893051 PRJNA1195551_S_NODE_35097_length_172_cov_1.878049_g34744_i0 PRJNA1195551 35097 172 1.878049 3.23024428 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 61.6 3.13e-9   NR RHY33897.1 157072 g34744 i0 65.2 4.95348837209302 46 16 80.2 0 142 5 502 547 RHY33897.1 hypothetical protein DYB32_003863, partial [Aphanomyces invadans] diamond 852 61.6 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans

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