RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA450343" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_clade 1

  • Sar · 20 ✖

bioproject 1

  • PRJNA450343 · 20 ✖

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
1713900 1713900 PRJNA450343_P_NODE_12242_length_164_cov_0.886957_g12174_i0 PRJNA450343 12242 164 0.886957 1.45460948 Bacillaria paxillifer 3003 SAR_Eukaryotes SAR_Eukaryotes 241 2.72e-59   NTclustered gi|2202538966|gb|OM891872.1| 3003 g12174 i0 93.252 81.609756097561 163 11 99 0 2 164 4698 4536 Bacillaria paxillifer small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 13384 241 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Bacillaria Bacillaria paxillifer
6816851 6816851 PRJNA450343_P_NODE_8406_length_187_cov_1.471014_g8338_i0 PRJNA450343 8406 187 1.471014 2.75079618 Chlorellidium tetrabotrys 243652 SAR_Eukaryotes SAR_Eukaryotes 324 3.07e-84   NTclustered gi|46020003|emb|AJ580949.1| 243652 g8338 i0 100 91.4812834224599 175 0 94 0 12 186 1 175 Chlorellidium tetrabotrys partial 18S rRNA gene, strain SAG 5.90 blastn 17107 324 1 Eukaryota Sar     Xanthophyceae Mischococcales Botryochloridaceae Chlorellidium Chlorellidium tetrabotrys
8745490 8745490 PRJNA450343_P_NODE_2967_length_312_cov_2.631179_g2899_i0 PRJNA450343 2967 312 2.631179 8.20927848 root 1 Root_unresolved Root_unresolved 569 6.509999999999998e-158   NTclustered gi|291495600|gb|GU823227.1| 152704 g2899 i0 99.679 100.019230769231 312 0 100 1 1 312 579 269 Uncultured stramenopile clone A93F14RM1E05 18S ribosomal RNA gene, partial sequence blastn 31206 571 0.996497373029772 Eukaryota Sar             uncultured stramenopile
9366941 9366941 PRJNA450343_P_NODE_11268_length_166_cov_0.871795_g11200_i0 PRJNA450343 11268 166 0.871795 1.4471797 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 189 1.0199999999999999e-43   NTclustered gi|146161228|ref|XM_971777.2| 312017 g11200 i0 87.273 0.993975903614458 165 21 99 0 1 165 94 258 Tetrahymena thermophila SB210 ribosomal protein L11, amine-terminal domain protein partial mRNA blastn 165 189 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
13192589 13192589 PRJNA450343_P_NODE_11791_length_165_cov_0.879310_g11723_i0 PRJNA450343 11791 165 0.87931 1.4508615 Cryptosporidium viatorum 1176757 SAR_Eukaryotes SAR_Eukaryotes 113 6.240000000000001e-21   NTclustered gi|441431303|gb|JX978273.1| 1176757 g11723 i0 98.438 16.6484848484848 64 1 59 0 1 64 1887 1824 Cryptosporidium viatorum isolate Swec025 70 kDa heat shock protein (HSP70) gene, partial cds blastn 2747 113 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium viatorum
18290681 18290681 PRJNA450343_P_NODE_11935_length_165_cov_0.879310_g11867_i0 PRJNA450343 11935 165 0.87931 1.4508615 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 289 9.66e-74   NTclustered gi|2633519340|gb|OR805654.1| 2126271 g11867 i0 98.182 197.878787878788 165 3 100 0 1 165 121253 121417 Naviculales sp. strain SZCZO2114 plastid, complete genome blastn 32650 289 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
26871205 26871205 PRJNA450343_P_NODE_13621_length_161_cov_1.821429_g13553_i0 PRJNA450343 13621 161 1.821429 2.93250069 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 50.1 3.19e-5   NR XP_038969887.1 5851 g13553 i0 42.3 6.3167701863354 52 29 96.9 1 3 158 693 743 XP_038969887.1 general transcription factor 3C polypeptide 5, putative [Plasmodium knowlesi strain H] diamond 1017 50.4 0.994047619047619 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium knowlesi
26965723 26965723 PRJNA450343_P_NODE_5502_length_227_cov_0.859551_g5434_i0 PRJNA450343 5502 227 0.859551 1.95118077 root 1 Root_unresolved Root_unresolved 80.5 7.97e-18   NR CXH16301.1 5821 g5434 i0 78 1.33480176211454 50 11 66.1 0 225 76 11 60 CXH16301.1 hypothetical protein PBK173_000516600 [Plasmodium berghei] diamond 303 80.9 0.995055624227441 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium berghei
27408643 27408643 PRJNA450343_P_NODE_10723_length_167_cov_0.864407_g10655_i0 PRJNA450343 10723 167 0.864407 1.44355969 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 105 6.28e-27   NR P19666.1 5908 g10655 i0 87.3 1.97604790419162 55 7 98.8 0 165 1 74 128 P19666.1 RecName: Full=Superoxide dismutase [Fe] [Tetrahymena pyriformis] diamond 330 105 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
27503300 27503300 PRJNA450343_P_NODE_12983_length_163_cov_0.894737_g12915_i0 PRJNA450343 12983 163 0.894737 1.45842131 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 46.2 7.29e-4   NR OEU11196.1 635003 g12915 i0 55.2 1.38036809815951 29 13 53.4 0 89 3 39 67 OEU11196.1 hypothetical protein FRACYDRAFT_246308 [Fragilariopsis cylindrus CCMP1102] diamond 225 46.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
27629586 27629586 PRJNA450343_P_NODE_12964_length_163_cov_0.894737_g12896_i0 PRJNA450343 12964 163 0.894737 1.45842131 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 95.9 2.3699999999999998e-23   NR EWM26134.1 72520 g12896 i0 86.8 3.90184049079755 53 7 97.5 0 2 160 22 74 EWM26134.1 ribosomal protein l12 [Nannochloropsis gaditana] diamond 636 95.9 1 Eukaryota Sar     Eustigmatophyceae Eustigmatales Monodopsidaceae Nannochloropsis Nannochloropsis gaditana
27802752 27802752 PRJNA450343_P_NODE_11904_length_165_cov_0.879310_g11836_i0 PRJNA450343 11904 165 0.87931 1.4508615 Parmales sp. scaly parma 2962637 SAR_Eukaryotes SAR_Eukaryotes 68.9 7.3e-12   NR GMI61125.1 2962637 g11836 i0 59.3 44.1454545454545 54 22 98.2 0 163 2 305 358 GMI61125.1 hypothetical protein ScalyP_jg10954 [Parmales sp. scaly parma] diamond 7284 68.9 1 Eukaryota Sar     Bolidophyceae Parmales     Parmales sp. scaly parma
28497357 28497357 PRJNA450343_P_NODE_14007_length_161_cov_0.910714_g13939_i0 PRJNA450343 14007 161 0.910714 1.46624954 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 74.3 8.86e-14   NR XP_001023679.2 312017 g13939 i0 76.6 0.875776397515528 47 11 87.6 0 15 155 2635 2681 XP_001023679.2 hypothetical protein TTHERM_00732810 [Tetrahymena thermophila SB210] diamond 141 74.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28829107 28829107 PRJNA450343_P_NODE_4308_length_256_cov_1.231884_g4240_i0 PRJNA450343 4308 256 1.231884 3.15362304 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 93.2 1.54e-21   NR OEU21027.1 635003 g4240 i0 58.3 3.90234375 84 32 97.3 3 249 1 98 179 OEU21027.1 winged helix DNA-binding domain-containing protein [Fragilariopsis cylindrus CCMP1102] diamond 999 93.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
29871219 29871219 PRJNA450343_P_NODE_12651_length_163_cov_1.342105_g12583_i0 PRJNA450343 12651 163 1.342105 2.18763115 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 116 1.46e-28   NR GFE53926.1 5869 g12583 i0 92.6 45.7177914110429 54 4 99.4 0 162 1 66 119 GFE53926.1 succinate flavo subunit [Babesia ovis] diamond 7452 117 0.991452991452991 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia ovis
29997704 29997704 PRJNA450343_P_NODE_9471_length_177_cov_1.585938_g9403_i0 PRJNA450343 9471 177 1.585938 2.80711026 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 50.8 1.56e-5   NR KAF4707660.1 32597 g9403 i0 47.8 4.77966101694915 46 24 78 0 140 3 171 216 KAF4707660.1 hypothetical protein FOZ63_017596, partial [Perkinsus olseni] diamond 846 50.8 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
30138880 30138880 PRJNA450343_P_NODE_8012_length_191_cov_1.436620_g7944_i0 PRJNA450343 8012 191 1.43662 2.7439442 Cafeteria roenbergensis 33653 SAR_Eukaryotes SAR_Eukaryotes 106 5.67e-25   NR KAA0150325.1 33653 g7944 i0 77.8 2.96858638743455 63 14 99 0 191 3 346 408 KAA0150325.1 hypothetical protein FNF29_05337 [Cafeteria roenbergensis] diamond 567 106 1 Eukaryota Sar     Bigyra Bicosoecida Cafeteriaceae Cafeteria Cafeteria roenbergensis
30424009 30424009 PRJNA450343_P_NODE_11253_length_166_cov_0.871795_g11185_i0 PRJNA450343 11253 166 0.871795 1.4471797 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 66.2 6.76e-11   NR KAI2507300.1 210448 g11185 i0 62.5 1.96987951807229 56 20 99.4 1 1 165 462 517 KAI2507300.1 hypothetical protein MHU86_7136 [Fragilaria crotonensis] diamond 327 66.2 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30455565 30455565 PRJNA450343_P_NODE_12853_length_163_cov_0.894737_g12785_i0 PRJNA450343 12853 163 0.894737 1.45842131 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 89 3.57e-19   NR XP_001022599.2 312017 g12785 i0 74.1 0.993865030674847 54 14 99.4 0 162 1 34 87 XP_001022599.2 granule lattice protein [Tetrahymena thermophila SB210] diamond 162 89 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31371846 31371846 PRJNA450343_P_NODE_12576_length_164_cov_0.886957_g12508_i0 PRJNA450343 12576 164 0.886957 1.45460948 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 83.2 7.05e-17   NR XP_002181347.1 556484 g12508 i0 77.4 0.969512195121951 53 12 97 0 164 6 282 334 XP_002181347.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 159 83.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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