RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA414036" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 13 ✖

tax_clade 1

bioproject 1

  • PRJNA414036 · 13 ✖

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
10622721 10622721 PRJNA414036_P_NODE_76709_length_168_cov_11.368421_g74970_i0 PRJNA414036 76709 168 11.368421 19.09894728 Sundstroemia setigera 3005 SAR_Eukaryotes SAR_Eukaryotes 209 7.9100000000000005e-50   NTclustered gi|1341066365|gb|MG914094.1| 3005 g74970 i0 90.566 94.4047619047619 159 13 94 2 2 159 781 624 Rhizosolenia setigera isolate SKLMP_YG110 large subunit ribosomal RNA gene, partial sequence blastn 15860 209 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Sundstroemia Sundstroemia setigera
11897707 11897707 PRJNA414036_P_NODE_87970_length_151_cov_833.439655_g86231_i0 PRJNA414036 87970 151 833.439655 1258.49387905 Gomphonema parvulum 97227 SAR_Eukaryotes SAR_Eukaryotes 211 1.92e-50   NTclustered gi|2444483125|gb|OP718169.1| 97227 g86231 i0 95.455 282.774834437086 132 6 87 0 20 151 73617 73486 Gomphonema parvulum chloroplast, complete genome blastn 42699 211 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
13836390 13836390 PRJNA414036_P_NODE_40071_length_232_cov_4.152284_g38332_i0 PRJNA414036 40071 232 4.152284 9.63329888 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 145 3.33e-30   NTclustered gi|1858914629|gb|MT634379.1| 2850 g38332 i0 100 46.6637931034483 78 0 34 0 155 232 182 259 Phaeodactylum tricornutum isolate 863-4 small subunit ribosomal RNA gene, partial sequence blastn 10826 145 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
13836409 13836409 PRJNA414036_P_NODE_45611_length_231_cov_3.132653_g43872_i0 PRJNA414036 45611 231 3.132653 7.23642843 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 130 9.27e-26   NTclustered gi|1779750597|gb|MN750505.1| 2679988 g43872 i0 98.649 32.8961038961039 74 0 32 1 157 230 861 789 Tryblionella cf. compressa strain TRY1006CAT small subunit ribosomal RNA gene, partial sequence blastn 7599 130 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Tryblionella Tryblionella cf. compressa
15110654 15110654 PRJNA414036_P_NODE_34192_length_254_cov_4.634703_g32456_i0 PRJNA414036 34192 254 4.634703 11.77214562 Chaetoceros 49237 SAR_Eukaryotes SAR_Eukaryotes 147 1.03e-30   NTclustered gi|2862228849|gb|PQ645483.1| 426624 g32456 i0 93.814 40.1968503937008 97 6 38 0 149 245 3643 3547 Chaetoceros atlanticus isolate AGSB0313 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 10210 147 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros atlanticus
15721431 15721431 PRJNA414036_P_NODE_44693_length_231_cov_3.377551_g42954_i0 PRJNA414036 44693 231 3.377551 7.80214281 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 111 3.36e-20   NTclustered gi|2633519340|gb|OR805654.1| 2126271 g42954 i0 97.015 46.2943722943723 67 1 57 1 10 75 121826 121892 Naviculales sp. strain SZCZO2114 plastid, complete genome blastn 10694 111 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
16385371 16385371 PRJNA414036_P_NODE_52753_length_231_cov_1.755102_g51014_i0 PRJNA414036 52753 231 1.755102 4.05428562 root 1 Root_unresolved Root_unresolved 122 1.55e-23   NTclustered gi|2739942905|dbj|LC814765.1| 2843 g51014 i0 100 44.030303030303 66 0 29 0 10 75 5827 5762 Skeletonema costatum SCHP35 chloroplast DNA, complete genome blastn 10171 122 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum
16385421 16385421 PRJNA414036_P_NODE_80993_length_161_cov_3.960317_g79254_i0 PRJNA414036 80993 161 3.960317 6.37611037 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.013   NTclustered gi|2172620591|ref|NC_059929.1| 671091 g79254 i0 96.774 0.732919254658385 31 1 19 0 102 132 12822 12852 Coscinodiscus wailesii chloroplast, complete genome blastn 118 52.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus wailesii
26980561 26980561 PRJNA414036_P_NODE_22802_length_317_cov_6.046099_g21071_i0 PRJNA414036 22802 317 6.046099 19.16613383 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 46.6 0.00354   NR EJK60870.1 159749 g21071 i0 37.6 0.8801261829653 93 56 88 1 31 309 35 125 EJK60870.1 hypothetical protein THAOC_18712 [Thalassiosira oceanica] diamond 279 46.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
27833566 27833566 PRJNA414036_P_NODE_73484_length_175_cov_2.400000_g71745_i0 PRJNA414036 73484 175 2.4 4.2 Toxarium undulatum 210620 SAR_Eukaryotes SAR_Eukaryotes 51.2 8.16e-6   NR YP_009495475.1 210620 g71745 i0 56.3 1.64571428571429 48 21 82.3 0 17 160 110 157 YP_009495475.1 NADH dehydrogenase subunit 9 [Toxarium undulatum] diamond 288 51.2 1 Eukaryota Sar   Bacillariophyta Mediophyceae Toxariales Toxariaceae Toxarium Toxarium undulatum
28780711 28780711 PRJNA414036_P_NODE_1667_length_659_cov_4.157051_g845_i2 PRJNA414036 1667 659 4.157051 27.39496609 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.0466   NR EJK75129.1 159749 g845 i2 36.4 0.851289833080425 99 63 45.1 0 488 192 5 103 EJK75129.1 hypothetical protein THAOC_03160, partial [Thalassiosira oceanica] diamond 561 46.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
30391971 30391971 PRJNA414036_P_NODE_1073_length_718_cov_2.900439_g845_i1 PRJNA414036 1073 718 2.900439 20.82515202 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 63.5 6.79e-8   NR EJK75129.1 159749 g845 i1 39.2 0.426183844011142 102 62 42.6 0 497 192 2 103 EJK75129.1 hypothetical protein THAOC_03160, partial [Thalassiosira oceanica] diamond 306 63.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
30517882 30517882 PRJNA414036_P_NODE_14853_length_382_cov_16.700288_g13174_i0 PRJNA414036 14853 382 16.700288 63.79510016 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 71.2 3.14e-12   NR EJK73956.1 159749 g13174 i0 35.7 0.879581151832461 112 72 88 0 380 45 90 201 EJK73956.1 hypothetical protein THAOC_04400 [Thalassiosira oceanica] diamond 336 71.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica

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