RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJEB28062", 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

  • PRJEB28062 · 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
25714 25714 PRJEB28062_P_NODE_91401_length_340_cov_71.078652_g89039_i0 PRJEB28062 91401 340 71.078652 241.6674168 Ulnaria acus 1436140 SAR_Eukaryotes SAR_Eukaryotes 558 1.55e-154   NTclustered gi|378824466|ref|NC_016731.1| 1436140 g89039 i0 98.423 8.47352941176471 317 5 93 0 2 318 82001 82317 Synedra acus chloroplast, complete genome blastn 2881 558 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria acus
9916006 9916006 PRJEB28062_P_NODE_79568_length_378_cov_11.344262_g77206_i0 PRJEB28062 79568 378 11.344262 42.88131036 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 78.7 5.94e-10   NTclustered gi|2852238308|gb|PQ498360.1| 189737 g77206 i0 94.118 2.11375661375661 51 3 13 0 231 281 33841 33791 Pseudo-nitzschia galaxiae isolate CNS01103 mitochondrion, complete genome blastn 799 78.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia galaxiae
10226295 10226295 PRJEB28062_P_NODE_105169_length_299_cov_26.075221_g102806_i0 PRJEB28062 105169 299 26.075221 77.96491079 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 58.5 1.85e-7   NR GKY95628.1 2872254 g102806 i0 74.3 0.702341137123746 35 9 35.1 0 297 193 328 362 GKY95628.1 hypothetical protein MPSEU_000524100 [Mayamaea pseudoterrestris] diamond 210 58.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
10228571 10228571 PRJEB28062_P_NODE_94429_length_331_cov_8.279070_g92067_i0 PRJEB28062 94429 331 8.27907 27.4037217 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 374 5.859999999999998e-99   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g92067 i0 88.365 81.8066465256798 318 27 93 8 23 331 4524 4840 Naviculales sp. strain SZCZO2114 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 27078 374 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
12777997 12777997 PRJEB28062_P_NODE_27071_length_713_cov_38.162500_g24816_i0 PRJEB28062 27071 713 38.1625 272.098625 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 935 0   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g24816 i0 91.185 97.9565217391304 692 56 97 5 2 692 4918 4231 Naviculales sp. strain SZCZO2114 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 69843 935 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
12778908 12778908 PRJEB28062_P_NODE_71431_length_406_cov_5.699700_g69070_i0 PRJEB28062 71431 406 5.6997 23.140782 Tabularia sp. 2508070 SAR_Eukaryotes SAR_Eukaryotes 510 5.3499999999999995e-140   NTclustered gi|2862228887|gb|PQ645521.1| 2508070 g69070 i0 90.746 90.5394088669951 389 26 95 7 1 387 4342 3962 Tabularia sp. isolate AGSB0382 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 36759 510 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Tabularia Tabularia sp.
17565469 17565469 PRJEB28062_P_NODE_5454_length_1709_cov_70.490220_g4332_i0 PRJEB28062 5454 1709 70.49022 1204.6778598 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 645 6.349999999999999e-180   NTclustered gi|2632235335|gb|OR922717.1| 2856 g4332 i0 85.913 56.7753071971913 646 43 45 18 86 725 2703 3306 Cylindrotheca closterium strain AGSB0133 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 97029 649 0.993836671802773 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
17875281 17875281 PRJEB28062_P_NODE_111015_length_283_cov_39.138095_g108652_i0 PRJEB28062 111015 283 39.138095 110.76080885 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 89.8 1.99e-13   NTclustered gi|219124223|ref|XM_002182373.1| 556484 g108652 i0 76.023 0.604240282685512 171 41 60 0 90 260 1364 1194 Phaeodactylum tricornutum CCAP 1055/1 predicted protein mRNA blastn 171 89.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
18838863 18838863 PRJEB28062_P_NODE_133095_length_232_cov_8.584906_g130731_i0 PRJEB28062 133095 232 8.584906 19.91698192 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 132 2.59e-26   NTclustered gi|2168682389|gb|MW561352.1| 67476 g130731 i0 89.524 42.6853448275862 105 9 44 2 130 232 6373 6477 Haslea ostrearia strain SZCZP1883 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 9903 132 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea ostrearia
18839141 18839141 PRJEB28062_P_NODE_32635_length_643_cov_6.473684_g30330_i0 PRJEB28062 32635 643 6.473684 41.62578812 Gomphonemataceae 97225 SAR_Eukaryotes SAR_Eukaryotes 1074 0   NTclustered gi|2328365172|ref|NC_067848.1| 97227 g30330 i0 98.682 185.968895800933 607 5 94 3 23 626 72486 73092 Gomphonema parvulum voucher personal collection:A.Bruce Cahoon:diatom-2021-A chloroplast, complete genome blastn 119578 1074 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
26716237 26716237 PRJEB28062_P_NODE_134361_length_227_cov_21.051948_g131997_i0 PRJEB28062 134361 227 21.051948 47.78792196 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 52 1.63e-5   NR CAB9508794.1 568900 g131997 i0 81.5 0.713656387665198 27 5 35.7 0 204 124 452 478 CAB9508794.1 factor 3 subunit E [Seminavis robusta] diamond 162 52 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27222614 27222614 PRJEB28062_P_NODE_111083_length_283_cov_7.314286_g108720_i0 PRJEB28062 111083 283 7.314286 20.69942938 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 85.1 7.81e-17   NR GKY99969.1 2872254 g108720 i0 62.7 0.625441696113074 59 22 62.5 0 259 83 745 803 GKY99969.1 hypothetical protein MPSEU_000950500 [Mayamaea pseudoterrestris] diamond 177 85.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28858308 28858308 PRJEB28062_P_NODE_40688_length_569_cov_24.723790_g38354_i0 PRJEB28062 40688 569 24.72379 140.6783651 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 170 1.4899999999999999e-46   NR KAG7338049.1 303405 g38354 i0 67.8 1.21792618629174 118 38 62.2 0 136 489 391 508 KAG7338049.1 MATE efflux family protein [Nitzschia inconspicua] diamond 693 171 0.994152046783626 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
29054463 29054463 PRJEB28062_P_NODE_137508_length_203_cov_9.084615_g135144_i0 PRJEB28062 137508 203 9.084615 18.44176845 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 56.6 1.35e-7   NR CAJ1930569.1 2856 g135144 i0 86.2 0.857142857142857 29 4 42.9 0 22 108 180 208 CAJ1930569.1 unnamed protein product [Cylindrotheca closterium] diamond 174 56.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30349709 30349709 PRJEB28062_P_NODE_138032_length_199_cov_5.769841_g135668_i0 PRJEB28062 138032 199 5.769841 11.48198359 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 105 5.28e-26   NR KAI2496222.1 210448 g135668 i0 87.3 0.829145728643216 55 7 82.9 0 23 187 216 270 KAI2496222.1 hypothetical protein MHU86_18273 [Fragilaria crotonensis] diamond 165 105 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30728285 30728285 PRJEB28062_P_NODE_72154_length_403_cov_133.103030_g69793_i0 PRJEB28062 72154 403 133.10303 536.4052109 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 88.2 4.53e-18   NR GKY90595.1 2872254 g69793 i0 51.4 0.781637717121588 105 40 70 2 26 307 170 274 GKY90595.1 hypothetical protein MPSEU_000033200 [Mayamaea pseudoterrestris] diamond 315 88.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
30949637 30949637 PRJEB28062_P_NODE_133434_length_231_cov_4.481013_g131070_i0 PRJEB28062 133434 231 4.481013 10.35114003 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 72.8 1.19e-13   NR KAG7356920.1 303405 g131070 i0 89.7 1.01298701298701 39 4 50.6 0 12 128 160 198 KAG7356920.1 chlorophyll A-B binding protein [Nitzschia inconspicua] diamond 234 72.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
30981299 30981299 PRJEB28062_P_NODE_77314_length_386_cov_2.929712_g74952_i0 PRJEB28062 77314 386 2.929712 11.30868832 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 67 1.7e-11   NR KAI2510103.1 210448 g74952 i0 80 0.272020725388601 35 7 27.2 0 169 65 68 102 KAI2510103.1 hypothetical protein MHU86_4270 [Fragilaria crotonensis] diamond 105 67 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32278001 32278001 PRJEB28062_P_NODE_136539_length_212_cov_5.187050_g134175_i0 PRJEB28062 136539 212 5.18705 10.996546 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.00545   NR KAI2504924.1 210448 g134175 i0 68 0.35377358490566 25 8 35.4 0 187 113 68 92 KAI2504924.1 hypothetical protein MHU86_9533 [Fragilaria crotonensis] diamond 75 42.7 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32436252 32436252 PRJEB28062_P_NODE_119139_length_262_cov_16.931217_g116776_i0 PRJEB28062 119139 262 16.931217 44.35978854 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 63.2 5.89e-10   NR KAI2491859.1 210448 g116776 i0 64 1.69465648854962 50 18 57.3 0 262 113 126 175 KAI2491859.1 chlorophyll A-B binding protein [Fragilaria crotonensis] diamond 444 63.2 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis

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