RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where bioproject = "PRJNA1008624" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

analysis 2

tax_superkingdom 1

tax_clade 1

  • Sar · 27 ✖

bioproject 1

  • PRJNA1008624 · 27 ✖

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
3551910 3551910 PRJNA1008624_P_NODE_2843_length_510_cov_5.600868_g2662_i0 PRJNA1008624 2843 510 5.600868 28.5644268 root 1 Root_unresolved Root_unresolved 909 0   NTclustered gi|197359040|gb|FJ002189.1| 29204 g2662 i0 99.016 111.362745098039 508 3 99 2 3 508 859 352 Cyclotella cryptica isolate C114 16S ribosomal RNA gene, partial sequence; chloroplast blastn 56795 918 0.990196078431373 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
3980450 3980450 PRJNA1008624_P_NODE_16084_length_211_cov_5.796296_g15896_i0 PRJNA1008624 16084 211 5.796296 12.23018456 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 366 5.83e-97   NTclustered gi|1169296926|gb|KY364696.1| 29205 g15896 i0 98.551 78.9194312796209 207 3 98 0 4 210 5617 5823 Cyclotella meneghiniana 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 16652 366 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
4829353 4829353 PRJNA1008624_P_NODE_3644_length_450_cov_1.850374_g3458_i0 PRJNA1008624 3644 450 1.850374 8.326683 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 784 0   NTclustered gi|1803023461|gb|MN937452.1| 2850 g3458 i0 98.427 196.635555555556 445 7 99 0 3 447 68871 68427 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 88486 787 0.996188055908513 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
6532070 6532070 PRJNA1008624_P_NODE_12566_length_236_cov_1.620321_g12378_i0 PRJNA1008624 12566 236 1.620321 3.82395756 Trithigmostoma cucullulus 1346499 SAR_Eukaryotes SAR_Eukaryotes 274 4.15e-69   NTclustered gi|759083539|gb|KM222156.1| 1346499 g12378 i0 89.593 74.1652542372881 221 15 92 6 12 228 112 328 Trithigmostoma cucullulus voucher CXM08110902 large subunit ribosomal RNA gene, partial sequence blastn 17503 274 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Trithigmostoma Trithigmostoma cucullulus
6532632 6532632 PRJNA1008624_P_NODE_32326_length_165_cov_0.896552_g32138_i0 PRJNA1008624 32326 165 0.896552 1.4793108 Nitzschia reversa 2675857 SAR_Eukaryotes SAR_Eukaryotes 150 4.76e-32   NTclustered gi|2721953992|gb|OR464345.1| 2675857 g32138 i0 92.381 62.8363636363636 105 8 64 0 32 136 55547 55443 Nitzschia reversa mitochondrion, complete genome blastn 10368 150 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
9929322 9929322 PRJNA1008624_P_NODE_10228_length_261_cov_1.495283_g10040_i0 PRJNA1008624 10228 261 1.495283 3.90268863 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 449 7.22e-122   NTclustered gi|98978883|gb|DQ512402.1| 29205 g10040 i0 97.71 100.314176245211 262 4 99 1 1 260 340 79 Cyclotella menegheniana strain F8 large subunit ribosomal RNA gene, partial sequence blastn 26182 449 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
10357223 10357223 PRJNA1008624_P_NODE_18289_length_199_cov_2.253333_g18101_i0 PRJNA1008624 18289 199 2.253333 4.48413267 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 357 3.2699999999999996e-94   NTclustered gi|512134943|gb|JX178902.1| 1295638 g18101 i0 99.49 98.5879396984925 196 1 98 0 1 196 1376 1181 Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 19619 357 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
11633356 11633356 PRJNA1008624_P_NODE_9270_length_275_cov_1.398230_g9082_i0 PRJNA1008624 9270 275 1.39823 3.8451325 Nitzschia anatoliensis 2862141 SAR_Eukaryotes SAR_Eukaryotes 398 2.8199999999999996e-106   NTclustered gi|2072715385|gb|MT740317.1| 2862141 g9082 i0 93.04 99.1018181818182 273 17 99 2 2 273 5743 5472 Nitzschia anatoliensis clone SZCZ E372 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 27253 398 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia anatoliensis
12908002 12908002 PRJNA1008624_P_NODE_25951_length_172_cov_1.406504_g25763_i0 PRJNA1008624 25951 172 1.406504 2.41918688 Navicula ramosissima 265559 SAR_Eukaryotes SAR_Eukaryotes 263 6.12e-66   NTclustered gi|1102548834|ref|NC_031848.1| 265559 g25763 i0 94.675 96.5 169 9 98 0 4 172 20901 20733 Navicula ramosissima voucher 10.TA439.Nram.mt mitochondrion, complete genome blastn 16598 263 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula ramosissima
22678122 22678122 PRJNA1008624_P_NODE_12078_length_240_cov_3.214660_g11890_i0 PRJNA1008624 12078 240 3.21466 7.715184 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 388 1.45e-103   NTclustered gi|1169296927|gb|KY364697.1| 29204 g11890 i0 96.203 99.3458333333333 237 9 99 0 1 237 4270 4034 Cyclotella cryptica 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 23843 388 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
23106234 23106234 PRJNA1008624_P_NODE_14519_length_221_cov_1.622093_g14331_i0 PRJNA1008624 14519 221 1.622093 3.58482553 Navicula avium 2018708 SAR_Eukaryotes SAR_Eukaryotes 211 3.05e-50   NTclustered gi|2721953916|gb|OR464343.1| 2018708 g14331 i0 86.598 16.5882352941176 194 22 87 4 3 194 47072 47263 Haslea avium mitochondrion, complete genome blastn 3666 211 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula avium
24380081 24380081 PRJNA1008624_P_NODE_17260_length_205_cov_1.179487_g17072_i0 PRJNA1008624 17260 205 1.179487 2.41794835 Amphifilidae sp. H-1 1407012 SAR_Eukaryotes SAR_Eukaryotes 363 7.279999999999998e-96   NTclustered gi|550533551|dbj|AB856528.1| 1407012 g17072 i0 99.01 79.1658536585366 202 2 99 0 1 202 908 707 Amphifilidae sp. H-1 gene for 18S ribosomal RNA, partial sequence blastn 16229 363 1 Eukaryota Sar     Bigyra Amphifilida Amphifilaceae   Amphifilidae sp. H-1
27223979 27223979 PRJNA1008624_P_NODE_35443_length_163_cov_0.912281_g35255_i0 PRJNA1008624 35443 163 0.912281 1.48701803 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 73.9 8.12e-14   NR CAG9328584.1 1481888 g35255 i0 72.1 0.791411042944785 43 12 79.1 0 161 33 158 200 CAG9328584.1 unnamed protein product [Blepharisma stoltei] diamond 129 73.9 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
27382273 27382273 PRJNA1008624_P_NODE_20123_length_191_cov_1.823944_g19935_i0 PRJNA1008624 20123 191 1.823944 3.48373304 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 69.7 5.69e-12   NR CAB9528269.1 568900 g19935 i0 47.6 0.989528795811518 63 33 99 0 3 191 372 434 CAB9528269.1 Inherit from euNOG: Reverse transcriptase (RNA-dependent DNA polymerase) [Seminavis robusta] diamond 189 69.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27792791 27792791 PRJNA1008624_P_NODE_27364_length_169_cov_0.866667_g27176_i0 PRJNA1008624 27364 169 0.866667 1.46466723 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 58.9 1.63e-8   NR GLE09482.1 114742 g27176 i0 60.4 3.76331360946746 53 20 92.3 1 163 8 106 158 GLE09482.1 hypothetical protein PINS_up021188 [Pythium insidiosum] diamond 636 58.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
28297755 28297755 PRJNA1008624_P_NODE_37006_length_162_cov_0.920354_g36818_i0 PRJNA1008624 37006 162 0.920354 1.49097348 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00143   NR KAI2490444.1 210448 g36818 i0 47.5 2.22222222222222 40 20 74.1 1 43 162 96 134 KAI2490444.1 hypothetical protein MHU86_24131 [Fragilaria crotonensis] diamond 360 45.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28424264 28424264 PRJNA1008624_P_NODE_30146_length_167_cov_0.881356_g29958_i0 PRJNA1008624 30146 167 0.881356 1.47186452 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 79.7 1.18e-15   NR KAI9995130.1 4787 g29958 i0 66.7 2.74850299401198 51 17 91.6 0 154 2 285 335 KAI9995130.1 hypothetical protein PInf_012177 [Phytophthora infestans] diamond 459 79.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
28487382 28487382 PRJNA1008624_P_NODE_28847_length_168_cov_0.873950_g28659_i0 PRJNA1008624 28847 168 0.87395 1.468236 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 106 5.66e-25   NR OMJ68454.1 5963 g28659 i0 92.6 0.964285714285714 54 4 96.4 0 6 167 3117 3170 OMJ68454.1 hypothetical protein SteCoe_34092 [Stentor coeruleus] diamond 162 106 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
28550643 28550643 PRJNA1008624_P_NODE_27567_length_169_cov_0.866667_g27379_i0 PRJNA1008624 27567 169 0.866667 1.46466723 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 53.1 2.83e-6   NR CAB9521594.1 568900 g27379 i0 49.1 0.940828402366864 53 27 94.1 0 161 3 794 846 CAB9521594.1 Reverse transcriptase (RNA-dependent DNA polymerase) (Partial), partial [Seminavis robusta] diamond 159 53.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28708463 28708463 PRJNA1008624_P_NODE_32327_length_165_cov_0.896552_g32139_i0 PRJNA1008624 32327 165 0.896552 1.4793108 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 69.7 3.88e-12   NR CAB9525983.1 568900 g32139 i0 57.4 0.981818181818182 54 23 98.2 0 164 3 232 285 CAB9525983.1 unknown protein [Seminavis robusta] diamond 162 69.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29655116 29655116 PRJNA1008624_P_NODE_35610_length_163_cov_0.912281_g35422_i0 PRJNA1008624 35610 163 0.912281 1.48701803 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 49.7 4.51e-5   NR CAB9527445.1 568900 g35422 i0 48.8 2.57668711656442 41 21 75.5 0 123 1 339 379 CAB9527445.1 hypothetical protein SEMRO_1998_G310121.1 [Seminavis robusta] diamond 420 49.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30887584 30887584 PRJNA1008624_P_NODE_32294_length_165_cov_0.896552_g32106_i0 PRJNA1008624 32294 165 0.896552 1.4793108 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 50.4 2.42e-5   NR CAI2360389.1 5936 g32106 i0 92.3 0.472727272727273 26 2 47.3 0 86 163 293 318 CAI2360389.1 unnamed protein product [Moneuplotes crassus] diamond 78 50.4 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
31488447 31488447 PRJNA1008624_P_NODE_22856_length_182_cov_1.406015_g22668_i0 PRJNA1008624 22856 182 1.406015 2.5589473 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 114 1.02e-27   NR CAB9505263.1 568900 g22668 i0 89.5 0.93956043956044 57 6 94 0 176 6 1566 1622 CAB9505263.1 NADH dehydrogenase (ubiquinone) complex I, assembly factor 6 [Seminavis robusta] diamond 171 114 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31899426 31899426 PRJNA1008624_P_NODE_29897_length_167_cov_0.881356_g29709_i0 PRJNA1008624 29897 167 0.881356 1.47186452 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 82 1.88e-16   NR KAJ1442902.1 483371 g29709 i0 75.5 0.952095808383233 53 12 95.2 1 3 161 611 662 KAJ1442902.1 P-loop containing nucleoside triphosphate hydrolase protein [Ochromonadaceae sp. CCMP2298] diamond 159 82 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
32215911 32215911 PRJNA1008624_P_NODE_28498_length_168_cov_0.873950_g28310_i0 PRJNA1008624 28498 168 0.87395 1.468236 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 41.2 0.046   NR CDW74479.1 5949 g28310 i0 54.8 0.553571428571429 31 14 55.4 0 115 23 216 246 CDW74479.1 UNKNOWN [Stylonychia lemnae] diamond 93 41.2 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32342621 32342621 PRJNA1008624_P_NODE_28519_length_168_cov_0.873950_g28331_i0 PRJNA1008624 28519 168 0.87395 1.468236 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 64.3 3.39e-10   NR CAI2384268.1 5936 g28331 i0 58.3 0.857142857142857 48 20 85.7 0 10 153 534 581 CAI2384268.1 unnamed protein product [Moneuplotes crassus] diamond 144 64.3 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
32721328 32721328 PRJNA1008624_P_NODE_31220_length_166_cov_0.888889_g31032_i0 PRJNA1008624 31220 166 0.888889 1.47555574 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 60.5 7.37e-9   NR GKY94061.1 2872254 g31032 i0 50 1.89759036144578 52 26 94 0 163 8 381 432 GKY94061.1 hypothetical protein MPSEU_000372700 [Mayamaea pseudoterrestris] diamond 315 60.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris

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