RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJEB56699" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

  • Sar · 22 ✖

bioproject 1

  • PRJEB56699 · 22 ✖

analysis 1

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
124579 124579 PRJEB56699_P_NODE_6161_length_172_cov_1.951049_g5931_i0 PRJEB56699 6161 172 1.951049 3.35580428 Navicula avium 2018708 SAR_Eukaryotes SAR_Eukaryotes 84.2 5.12e-12   NTclustered gi|2202538973|gb|OM891879.1| 2018708 g5931 i0 76.19 24.2209302325581 168 35 97 4 7 172 5526 5362 Haslea avium 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 4166 84.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula avium
992053 992053 PRJEB56699_P_NODE_6661_length_151_cov_2.270492_g6431_i0 PRJEB56699 6661 151 2.270492 3.42844292 Thalassiosiraceae 29202 SAR_Eukaryotes SAR_Eukaryotes 279 5.19e-71   NTclustered gi|1169296926|gb|KY364696.1| 29205 g6431 i0 100 99.9867549668874 151 0 100 0 1 151 3761 3611 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 15098 279 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
2267279 2267279 PRJEB56699_P_NODE_6322_length_164_cov_2.355556_g6092_i0 PRJEB56699 6322 164 2.355556 3.86311184 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 276 7.46e-70   NTclustered gi|1783235058|gb|MN276191.1| 210602 g6092 i0 96.951 197.487804878049 164 5 100 0 1 164 98407 98244 Nanofrustulum shiloi strain SZCZM404 chloroplast, complete genome blastn 32388 276 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Staurosiraceae Nanofrustulum Nanofrustulum shiloi
3542563 3542563 PRJEB56699_P_NODE_1303_length_516_cov_4.870637_g1109_i0 PRJEB56699 1303 516 4.870637 25.13248692 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 682 0   NTclustered gi|1837628855|gb|MN158348.1| 5909 g1109 i0 94.831 85.0833333333333 445 10 86 3 1 444 2605 3037 Tetrahymena rostrata strain TRAUS 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 43903 682 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
5227147 5227147 PRJEB56699_P_NODE_2645_length_338_cov_3.763754_g2415_i0 PRJEB56699 2645 338 3.763754 12.72148852 Cymbella tumida 882190 SAR_Eukaryotes SAR_Eukaryotes 579 1.1799999999999999e-160   NTclustered gi|2162236538|gb|OL780393.1| 882190 g2415 i0 99.373 74.4881656804734 319 2 94 0 1 319 319 1 Cymbella tumida strain CBac2019069 large subunit ribosomal RNA gene, partial sequence blastn 25177 579 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Cymbella Cymbella tumida
6502838 6502838 PRJEB56699_P_NODE_2226_length_377_cov_6.833333_g1998_i0 PRJEB56699 2226 377 6.833333 25.76166541 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 359 1.89e-94   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g1998 i0 84.293 33.7082228116711 382 44 100 12 1 377 2203 2573 Rosculus vulgaris isolate CCA sequence blastn 12708 359 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
7777053 7777053 PRJEB56699_P_NODE_187_length_1300_cov_5.153423_g128_i0 PRJEB56699 187 1300 5.153423 66.994499 Rosculus philanguis 2231163 SAR_Eukaryotes SAR_Eukaryotes 1024 0   NTclustered gi|1402550480|gb|MH488766.1| 2231163 g128 i0 82.941 18.61 1190 150 89 41 1 1155 16 1187 Rosculus philanguis isolate HAS small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 24193 1024 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus philanguis
9051825 9051825 PRJEB56699_P_NODE_1568_length_462_cov_8.974596_g1358_i0 PRJEB56699 1568 462 8.974596 41.46263352 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 734 0   NTclustered gi|66571059|emb|AJ878485.1| 29205 g1358 i0 99.261 97.4025974025974 406 3 99 0 57 462 529 124 Cyclotella meneghiniana partial 28S rRNA gene, strain AT-51.12 blastn 45000 734 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
9051828 9051828 PRJEB56699_P_NODE_208_length_1244_cov_3.762140_g144_i0 PRJEB56699 208 1244 3.76214 46.8010216 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 593 1.6799999999999996e-164   NTclustered gi|1169296926|gb|KY364696.1| 29205 g144 i0 95.913 27.5192926045016 367 14 30 1 878 1244 3913 4278 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 34234 593 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
9051832 9051832 PRJEB56699_P_NODE_6588_length_154_cov_2.296000_g6358_i0 PRJEB56699 6588 154 2.296 3.53584 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 191 2.57e-44   NTclustered gi|146762526|gb|EF553458.1| 2850 g6358 i0 88.961 102.623376623377 154 17 100 0 1 154 4078 4231 Phaeodactylum tricornutum strain CCAP 1055/1 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 15804 191 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
10327643 10327643 PRJEB56699_P_NODE_209_length_1242_cov_8.654575_g145_i0 PRJEB56699 209 1242 8.654575 107.4898215 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 2047 0   NTclustered gi|1402550477|gb|MH488763.1| 2231161 g145 i0 98.116 16.9186795491143 1168 15 94 3 80 1242 1176 11 Rosculus hawesi isolate C1C small subunit ribosomal RNA gene, partial sequence blastn 21013 2047 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
12471006 12471006 PRJEB56699_P_NODE_3370_length_285_cov_2.156250_g3140_i0 PRJEB56699 3370 285 2.15625 6.1453125 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.002   NTclustered gi|2721953992|gb|OR464345.1| 2675857 g3140 i0 88.889 4.23157894736842 45 5 16 0 109 153 51172 51216 Nitzschia reversa mitochondrion, complete genome blastn 1206 56.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
12471008 12471008 PRJEB56699_P_NODE_4550_length_223_cov_7.237113_g4320_i0 PRJEB56699 4550 223 7.237113 16.13876199 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 401 1.7099999999999992e-107   NTclustered gi|2316016826|gb|OL855988.1| 59812 g4320 i0 99.103 198.017937219731 223 2 100 0 1 223 10580 10802 Lithodesmium undulatum chloroplast, complete genome blastn 44158 401 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Lithodesmium Lithodesmium undulatum
12878205 12878205 PRJEB56699_P_NODE_2331_length_366_cov_6.017804_g2103_i0 PRJEB56699 2331 366 6.017804 22.02516264 Navicula capitatoradiata 431397 SAR_Eukaryotes SAR_Eukaryotes 667 0   NTclustered gi|168145917|emb|AM710568.1| 431397 g2103 i0 99.454 97.6256830601093 366 2 100 0 1 366 102 467 Navicula capitatoradiata partial 28S rRNA gene, strain AT-212Gel07 blastn 35731 667 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula capitatoradiata
14153012 14153012 PRJEB56699_P_NODE_1292_length_518_cov_4.494888_g1098_i0 PRJEB56699 1292 518 4.494888 23.28351984 Coleps hirtus 60000 SAR_Eukaryotes SAR_Eukaryotes 475 2.5399999999999993e-129   NTclustered gi|328684911|gb|HM122027.1| 394492 g1098 i0 94.481 12.8745173745174 308 17 59 0 93 400 521 214 Coleps hirtus hirtus isolate SNK09101903 macronuclear blastn 6669 475 1 Eukaryota Sar   Ciliophora Prostomatea Prorodontida Colepidae Coleps Coleps hirtus
15019865 15019865 PRJEB56699_P_NODE_6692_length_150_cov_1.950413_g6462_i0 PRJEB56699 6692 150 1.950413 2.9256195 root 1 Root_unresolved Root_unresolved 58.4 2.63e-4   NTclustered gi|11466457|ref|NC_002174.1| 47573 g6462 i0 97.059 34.7466666666667 34 1 23 0 117 150 1936 1903 Chrysodidymus synuroideus mitochondrion, complete genome blastn 5212 58.4 1 Eukaryota Sar     Synurophyceae Synurales Mallomonadaceae Synura Synura synuroidea
16701320 16701320 PRJEB56699_P_NODE_4234_length_237_cov_2.187500_g4004_i0 PRJEB56699 4234 237 2.1875 5.184375 Euplotes vanleeuwenhoeki 2794224 SAR_Eukaryotes SAR_Eukaryotes 89.8 1.62e-13   NTclustered gi|2055401904|ref|NC_056101.1| 2794224 g4004 i0 86.585 33.4092827004219 82 10 35 1 3 84 4618 4698 Euplotes vanleeuwenhoeki strain KKR18 mitochondrion, complete genome blastn 7918 89.8 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes vanleeuwenhoeki
17569868 17569868 PRJEB56699_P_NODE_6074_length_176_cov_2.095238_g5844_i0 PRJEB56699 6074 176 2.095238 3.68761888 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 291 2.89e-74   NTclustered gi|114329811|ref|NC_008337.1| 5901 g5844 i0 96.591 23.1534090909091 176 4 100 2 1 176 32957 33130 Tetrahymena malaccensis mitochondrion, complete genome blastn 4075 291 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
20525531 20525531 PRJEB56699_P_NODE_4337_length_232_cov_5.699507_g4107_i0 PRJEB56699 4337 232 5.699507 13.22285624 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 412 8.26e-111   NTclustered gi|1169296926|gb|KY364696.1| 29205 g4107 i0 98.712 87.9439655172414 233 2 100 1 1 232 5610 5842 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 20403 412 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
21801341 21801341 PRJEB56699_P_NODE_1058_length_568_cov_5.280148_g882_i0 PRJEB56699 1058 568 5.280148 29.99124064 Coleps hirtus 60000 SAR_Eukaryotes SAR_Eukaryotes 989 0   NTclustered gi|2026535536|gb|MW929305.1| 60000 g882 i0 98.063 78.8045774647887 568 11 100 0 1 568 2775 2208 Coleps hirtus strain AG Berninger/Pickham Uni Salzburg 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 44761 989 1 Eukaryota Sar   Ciliophora Prostomatea Prorodontida Colepidae Coleps Coleps hirtus
21801342 21801342 PRJEB56699_P_NODE_2598_length_343_cov_2.041401_g2368_i0 PRJEB56699 2598 343 2.041401 7.00200543 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 490 5.799999999999999e-134   NTclustered gi|114329811|ref|NC_008337.1| 5901 g2368 i0 94.136 77.6239067055394 324 16 94 2 14 334 33301 33624 Tetrahymena malaccensis mitochondrion, complete genome blastn 26625 490 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
23944345 23944345 PRJEB56699_P_NODE_4479_length_226_cov_2.558376_g4249_i0 PRJEB56699 4479 226 2.558376 5.78192976 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 180 8.84e-41   NTclustered gi|1268580094|gb|KY218574.1| 5898 g4249 i0 100 51.2389380530973 97 0 75 0 1 97 444 540 Tetrahymena furgasoni isolate 20749-1 small subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 11580 180 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena furgasoni

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