RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA1123436", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 20 ✖

tax_clade 1

  • Sar · 20 ✖

bioproject 1

  • PRJNA1123436 · 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
1554688 1554688 PRJNA1123436_P_NODE_59742_length_322_cov_48.000000_g58528_i0 PRJNA1123436 59742 322 48 154.56 Cyclotella striata 382364 SAR_Eukaryotes SAR_Eukaryotes 274 5.929999999999998e-69   NTclustered gi|984294636|gb|KT390097.1| 382364 g58528 i0 99.338 62.1832298136646 151 1 89 0 3 153 799 649 Cyclotella striata clone ZX28-3-40 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 20023 274 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella striata
4106842 4106842 PRJNA1123436_P_NODE_46104_length_369_cov_2.337838_g44890_i0 PRJNA1123436 46104 369 2.337838 8.62662222 Thalassiosira bioculata 1048533 SAR_Eukaryotes SAR_Eukaryotes 656 0   NTclustered gi|2862228846|gb|PQ645480.1| 1048533 g44890 i0 98.91 99.479674796748 367 4 99 0 1 367 3606 3972 Thalassiosira bioculata isolate AGSB0307 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 36708 656 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira bioculata
6132637 6132637 PRJNA1123436_P_NODE_60125_length_321_cov_21.282258_g58911_i0 PRJNA1123436 60125 321 21.282258 68.31604818 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 254 7.69e-63   NTclustered gi|62766758|gb|AY911302.1| 259830 g58911 i0 100 61.6822429906542 137 0 61 0 171 307 647 511 Cyclotella cf. scaldensis G18W42 clone 6 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 19800 254 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cf. scaldensis G18W42
6658197 6658197 PRJNA1123436_P_NODE_76526_length_284_cov_2.175355_g75312_i0 PRJNA1123436 76526 284 2.175355 6.1780082 Aulacoseira granulata 285082 SAR_Eukaryotes SAR_Eukaryotes 368 2.29e-97   NTclustered gi|2245330033|gb|OK502185.1| 285082 g75312 i0 90.106 52.3802816901408 283 28 99 0 1 283 345 627 Aulacoseira granulata voucher Pichi9a 28S ribosomal RNA gene, partial sequence blastn 14876 368 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae   Aulacoseiraceae Aulacoseira Aulacoseira granulata
10483452 10483452 PRJNA1123436_P_NODE_51129_length_349_cov_1.884058_g49915_i0 PRJNA1123436 51129 349 1.884058 6.57536242 Paralia sulcata 216927 SAR_Eukaryotes SAR_Eukaryotes 285 2.9799999999999996e-72   NTclustered gi|2202538979|gb|OM891885.1| 216927 g49915 i0 82.111 44.756446991404 341 54 96 6 15 349 5834 5495 Paralia sulcata 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 15620 285 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Paraliales Paraliaceae Paralia Paralia sulcata
10484104 10484104 PRJNA1123436_P_NODE_85889_length_267_cov_1.190722_g84675_i0 PRJNA1123436 85889 267 1.190722 3.17922774 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 383 7.63e-102   NTclustered gi|146762526|gb|EF553458.1| 2850 g84675 i0 92.537 96.6217228464419 268 18 100 2 1 267 4418 4152 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 25798 383 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
11233080 11233080 PRJNA1123436_P_NODE_59409_length_323_cov_22.760000_g58195_i0 PRJNA1123436 59409 323 22.76 73.5148 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 254 7.75e-63   NTclustered gi|62766758|gb|AY911302.1| 259830 g58195 i0 100 62.5046439628483 137 0 61 0 173 309 647 511 Cyclotella cf. scaldensis G18W42 clone 6 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 20189 254 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cf. scaldensis G18W42
11758131 11758131 PRJNA1123436_P_NODE_35770_length_424_cov_1537.877493_g34556_i0 PRJNA1123436 35770 424 1537.877493 6520.60057032 Didymosphenia geminata 1115533 SAR_Eukaryotes SAR_Eukaryotes 745 0   NTclustered gi|662012825|ref|NC_024083.1| 1115533 g34556 i0 99.511 161.891509433962 409 2 96 0 14 422 69493 69085 Didymosphenia geminata chloroplast, complete genome blastn 68642 745 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Didymosphenia Didymosphenia geminata
15057627 15057627 PRJNA1123436_P_NODE_82992_length_272_cov_2.090452_g81778_i0 PRJNA1123436 82992 272 2.090452 5.68602944 Skeletonema 2842 SAR_Eukaryotes SAR_Eukaryotes 161 3.97e-35   NTclustered gi|642941637|dbj|AB948151.1| 2843 g81778 i0 88.235 46.9558823529412 136 15 50 1 126 260 437 302 Skeletonema costatum mitochondrial coxI gene for cytochrome oxidase subunit I, partial cds, strain: FAR002 blastn 12772 161 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum
18131990 18131990 PRJNA1123436_P_NODE_70195_length_297_cov_2.758929_g68981_i0 PRJNA1123436 70195 297 2.758929 8.19401913 Proschkinia sp. SZCZR1824 2588390 SAR_Eukaryotes SAR_Eukaryotes 143 1.59e-29   NTclustered gi|1681061561|gb|MH800316.1| 2588390 g68981 i0 86.719 46.3097643097643 128 17 43 0 16 143 39979 39852 Proschkinia sp. SZCZR1824 mitochondrion, complete genome blastn 13754 143 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Proschkiniaceae Proschkinia Proschkinia sp. SZCZR1824
19405677 19405677 PRJNA1123436_P_NODE_46096_length_369_cov_2.645270_g44882_i0 PRJNA1123436 46096 369 2.64527 9.7610463 Aulacoseira granulata 285082 SAR_Eukaryotes SAR_Eukaryotes 682 0   NTclustered gi|50345759|gb|AY569584.1| 285082 g44882 i0 100 98.6693766937669 369 0 100 0 1 369 901 533 Aulacoseira granulata strain LB 18S ribosomal RNA gene, partial sequence blastn 36409 682 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae   Aulacoseiraceae Aulacoseira Aulacoseira granulata
20156250 20156250 PRJNA1123436_P_NODE_73316_length_290_cov_1.585253_g72102_i0 PRJNA1123436 73316 290 1.585253 4.5972337 Cyclostephanos 382378 SAR_Eukaryotes SAR_Eukaryotes 521 1.7e-143   NTclustered gi|2131299562|gb|OL436673.1| 1003040 g72102 i0 98.966 98.6551724137931 290 3 100 0 1 290 295 6 Cyclostephanos dubius strain DOL38 large subunit ribosomal RNA gene, partial sequence blastn 28610 521 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos dubius
20680724 20680724 PRJNA1123436_P_NODE_129097_length_200_cov_513.724409_g127883_i0 PRJNA1123436 129097 200 513.724409 1027.448818 Ulnaria acus 1436140 SAR_Eukaryotes SAR_Eukaryotes 363 7.069999999999999e-96   NTclustered gi|378824466|ref|NC_016731.1| 1436140 g127883 i0 99.497 165.555 199 1 99 0 2 200 67148 67346 Synedra acus chloroplast, complete genome blastn 33111 363 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria acus
21431737 21431737 PRJNA1123436_P_NODE_68257_length_301_cov_33.245614_g67043_i0 PRJNA1123436 68257 301 33.245614 100.06929814 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 241 5.570000000000001e-59   NTclustered gi|758258028|gb|KM821127.1| 29204 g67043 i0 98.529 69.0099667774086 136 2 45 0 152 287 379 244 Cyclotella cryptica strain CCMA 237 internal transcribed spacer 1, partial sequence; and 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence blastn 20772 241 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
22706234 22706234 PRJNA1123436_P_NODE_129098_length_200_cov_105.976378_g127884_i0 PRJNA1123436 129098 200 105.976378 211.952756 Fragilariophyceae 33853 SAR_Eukaryotes SAR_Eukaryotes 350 5.5e-92   NTclustered gi|2497507580|gb|OQ694379.1| 1043707 g127884 i0 98.485 166.68 198 3 99 0 3 200 68580 68777 Fragilaria capucina var. mesolepta chloroplast, complete genome blastn 33336 350 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria capucina
23981794 23981794 PRJNA1123436_P_NODE_40259_length_397_cov_1.845679_g39045_i0 PRJNA1123436 40259 397 1.845679 7.32734563 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 658 0   NTclustered gi|2202538979|gb|OM891885.1| 216927 g39045 i0 96.717 99.7959697732997 396 12 99 1 1 396 3333 3727 Paralia sulcata 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 39619 664 0.990963855421687 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Paraliales Paraliaceae Paralia Paralia sulcata
23981834 23981834 PRJNA1123436_P_NODE_44759_length_375_cov_2.976821_g43545_i0 PRJNA1123436 44759 375 2.976821 11.16307875 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 684 0   NTclustered gi|98990738|gb|DQ514914.1| 29207 g43545 i0 99.732 99.4 373 1 99 0 3 375 383 11 Stephanodiscus hantzschii strain WTC21 18S small subunit ribosomal RNA gene, partial sequence blastn 37275 689 0.992743105950653 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus hantzschii
30386578 30386578 PRJNA1123436_P_NODE_119613_length_243_cov_0.905882_g118399_i0 PRJNA1123436 119613 243 0.905882 2.20129326 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 130 3.77e-33   NR GKY91322.1 2872254 g118399 i0 82.3 0.975308641975309 79 14 97.5 0 2 238 486 564 GKY91322.1 hypothetical protein MPSEU_000104400 [Mayamaea pseudoterrestris] diamond 237 130 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
31808663 31808663 PRJNA1123436_P_NODE_95517_length_251_cov_0.865169_g94303_i0 PRJNA1123436 95517 251 0.865169 2.17157419 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 92.8 1e-19   NR XP_002180731.1 556484 g94303 i0 79.1 0.800796812749004 67 13 78.9 1 199 2 660 726 XP_002180731.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 201 92.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32819872 32819872 PRJNA1123436_P_NODE_124760_length_242_cov_0.911243_g123546_i0 PRJNA1123436 124760 242 0.911243 2.20520806 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 166 2.2699999999999993e-46   NR KAL3761713.1 2934178 g123546 i0 98.8 0.991735537190083 80 1 99.2 0 2 241 253 332 KAL3761713.1 hypothetical protein ACHAW5_005964 [Stephanodiscus triporus] diamond 240 166 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus

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