RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA312107" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 21 ✖

bioproject 1

  • PRJNA312107 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
26947581 26947581 PRJNA312107_P_NODE_21582_length_166_cov_0.888889_g21416_i0 PRJNA312107 21582 166 0.888889 1.47555574 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 48.5 5.04e-5   NR ETO02802.1 46433 g21416 i0 40 0.993975903614458 55 31 99.4 1 1 165 16 68 ETO02802.1 hypothetical protein RFI_34611 [Reticulomyxa filosa] diamond 165 48.5 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
27358893 27358893 PRJNA312107_P_NODE_26003_length_162_cov_0.920354_g25837_i0 PRJNA312107 26003 162 0.920354 1.49097348 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 48.5 1.17e-4   NR CAB9524955.1 568900 g25837 i0 52.8 0.981481481481482 53 23 94.4 1 10 162 226 278 CAB9524955.1 Rhs element vgr protein [Seminavis robusta] diamond 159 48.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27502805 27502805 PRJNA312107_P_NODE_25803_length_162_cov_0.920354_g25637_i0 PRJNA312107 25803 162 0.920354 1.49097348 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 99.8 1.08e-22   NR XP_002185275.1 556484 g25637 i0 85.2 2 54 8 100 0 162 1 508 561 XP_002185275.1 isomerase glucose-6-phosphate isomerase [Phaeodactylum tricornutum CCAP 1055/1] diamond 324 99.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
28481432 28481432 PRJNA312107_P_NODE_18786_length_169_cov_0.866667_g18620_i0 PRJNA312107 18786 169 0.866667 1.46466723 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 74.3 9.69e-14   NR KAL4453236.1 5901 g18620 i0 81.8 1.56213017751479 44 8 78.1 0 164 33 492 535 KAL4453236.1 hypothetical protein ABPG73_022091 [Tetrahymena malaccensis] diamond 264 74.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
28796933 28796933 PRJNA312107_P_NODE_19087_length_169_cov_0.866667_g18921_i0 PRJNA312107 19087 169 0.866667 1.46466723 root 1 Root_unresolved Root_unresolved 43.5 0.0072   NR KAI2511222.1 210448 g18921 i0 43.6 1.7396449704142 39 22 69.2 0 3 119 624 662 KAI2511222.1 amino acid/polyamine antiporter [Fragilaria crotonensis] diamond 294 43.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28905666 28905666 PRJNA312107_P_NODE_19708_length_168_cov_0.873950_g19542_i0 PRJNA312107 19708 168 0.87395 1.468236 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 118 3.67e-29   NR CDW71673.1 5949 g19542 i0 94.5 0.982142857142857 55 3 98.2 0 2 166 538 592 CDW71673.1 ubiquitin-activating enzyme e1 family protein [Stylonychia lemnae] diamond 165 118 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29252947 29252947 PRJNA312107_P_NODE_19849_length_168_cov_0.873950_g19683_i0 PRJNA312107 19849 168 0.87395 1.468236 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 59.7 6.07e-10   NR GFH46685.1 426638 g19683 i0 60.4 0.857142857142857 48 18 85.7 1 18 161 16 62 GFH46685.1 hypothetical protein CTEN210_03159 [Chaetoceros tenuissimus] diamond 144 59.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30011216 30011216 PRJNA312107_P_NODE_25751_length_162_cov_0.920354_g25585_i0 PRJNA312107 25751 162 0.920354 1.49097348 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 45.4 2.84e-4   NR KAI2512131.1 210448 g25585 i0 51.2 0.796296296296296 43 19 75.9 1 1 123 3 45 KAI2512131.1 hypothetical protein MHU86_2218 [Fragilaria crotonensis] diamond 129 45.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30168834 30168834 PRJNA312107_P_NODE_22252_length_166_cov_0.888889_g22086_i0 PRJNA312107 22252 166 0.888889 1.47555574 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 97.1 9.94e-22   NR KAI2490391.1 210448 g22086 i0 69.1 0.993975903614458 55 17 99.4 0 166 2 678 732 KAI2490391.1 PKD domain [Fragilaria crotonensis] diamond 165 97.1 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30674455 30674455 PRJNA312107_P_NODE_24733_length_163_cov_0.912281_g24567_i0 PRJNA312107 24733 163 0.912281 1.48701803 Durusdinium trenchii 1381693 SAR_Eukaryotes SAR_Eukaryotes 65.5 1.22e-10   NR CAK9106307.1 1381693 g24567 i0 91.4 0.644171779141104 35 3 64.4 0 109 5 700 734 CAK9106307.1 Tape measure protein (TMP), partial [Durusdinium trenchii] diamond 105 65.5 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Durusdinium Durusdinium trenchii
30832511 30832511 PRJNA312107_P_NODE_25954_length_162_cov_0.920354_g25788_i0 PRJNA312107 25954 162 0.920354 1.49097348 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 55.8 2.89e-7   NR KAI2489055.1 210448 g25788 i0 65.3 0.907407407407407 49 17 90.7 0 151 5 250 298 KAI2489055.1 hypothetical protein MHU86_25544 [Fragilaria crotonensis] diamond 147 55.8 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30959024 30959024 PRJNA312107_P_NODE_22634_length_165_cov_0.896552_g22468_i0 PRJNA312107 22634 165 0.896552 1.4793108 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 80.9 4.59e-16   NR CAB9522332.1 568900 g22468 i0 58.8 0.927272727272727 51 21 92.7 0 12 164 605 655 CAB9522332.1 expressed unknown protein [Seminavis robusta] diamond 153 80.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31306530 31306530 PRJNA312107_P_NODE_22095_length_166_cov_0.888889_g21929_i0 PRJNA312107 22095 166 0.888889 1.47555574 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 90.5 1.9e-19   NR KAI2498239.1 210448 g21929 i0 87 2.92771084337349 54 7 97.6 0 164 3 1158 1211 KAI2498239.1 Abc transporter [Fragilaria crotonensis] diamond 486 90.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31401666 31401666 PRJNA312107_P_NODE_21776_length_166_cov_0.888889_g21610_i0 PRJNA312107 21776 166 0.888889 1.47555574 Psammoneis japonica 517775 SAR_Eukaryotes SAR_Eukaryotes 60.8 2.99e-9   NR YP_009495533.1 517775 g21610 i0 50 1.89759036144578 52 26 94 0 158 3 128 179 YP_009495533.1 ribosomal protein S4 [Psammoneis japonica] diamond 315 60.8 1 Eukaryota Sar   Bacillariophyta Mediophyceae Triceratiales Plagiogrammaceae Psammoneis Psammoneis japonica
31496577 31496577 PRJNA312107_P_NODE_21856_length_166_cov_0.888889_g21690_i0 PRJNA312107 21856 166 0.888889 1.47555574 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 63.5 5.81e-10   NR CAB9525008.1 568900 g21690 i0 76.3 0.686746987951807 38 9 68.7 0 119 6 603 640 CAB9525008.1 polymerase 1 [Seminavis robusta] diamond 114 63.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31591430 31591430 PRJNA312107_P_NODE_19216_length_169_cov_0.866667_g19050_i0 PRJNA312107 19216 169 0.866667 1.46466723 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00107   NR KAJ1417345.1 483371 g19050 i0 55.6 0.63905325443787 36 16 63.9 0 108 1 23 58 KAJ1417345.1 PqaA type PhoPQ-activated pathogenicity-related protein, partial [Ochromonadaceae sp. CCMP2298] diamond 108 45.8 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
32065670 32065670 PRJNA312107_P_NODE_10298_length_225_cov_1.181818_g10132_i0 PRJNA312107 10298 225 1.181818 2.6590905 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 89.7 8.48e-19   NR KAI2501705.1 210448 g10132 i0 62.5 0.853333333333333 64 24 85.3 0 193 2 2202 2265 KAI2501705.1 cholesterol oxidase [Fragilaria crotonensis] diamond 192 89.7 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32129242 32129242 PRJNA312107_P_NODE_21298_length_166_cov_1.777778_g21132_i0 PRJNA312107 21298 166 1.777778 2.95111148 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 58.2 1.09e-8   NR GKY99408.1 2872254 g21132 i0 50.9 0.993975903614458 55 27 99.4 0 2 166 63 117 GKY99408.1 hypothetical protein MPSEU_000895500 [Mayamaea pseudoterrestris] diamond 165 58.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32413910 32413910 PRJNA312107_P_NODE_21939_length_166_cov_0.888889_g21773_i0 PRJNA312107 21939 166 0.888889 1.47555574 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 100 4.36e-25   NR KAI2509358.1 210448 g21773 i0 98 0.885542168674699 49 1 88.6 0 165 19 137 185 KAI2509358.1 chlorophyll A-B binding protein [Fragilaria crotonensis] diamond 147 100 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32823923 32823923 PRJNA312107_P_NODE_19980_length_168_cov_0.873950_g19814_i0 PRJNA312107 19980 168 0.87395 1.468236 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 87.4 2.51e-18   NR KAI2501705.1 210448 g19814 i0 75.9 0.964285714285714 54 13 96.4 0 7 168 1926 1979 KAI2501705.1 cholesterol oxidase [Fragilaria crotonensis] diamond 162 87.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32886675 32886675 PRJNA312107_P_NODE_24920_length_163_cov_0.912281_g24754_i0 PRJNA312107 24920 163 0.912281 1.48701803 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 54.3 1.06e-6   NR XP_002182934.1 556484 g24754 i0 52.8 0.975460122699387 53 23 97.5 1 2 160 411 461 XP_002182934.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 159 54.3 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);;