RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA702290" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_clade 1

bioproject 1

  • PRJNA702290 · 9 ✖

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
4511843 4511843 PRJNA702290_P_NODE_244_length_297_cov_16.643411_g236_i0 PRJNA702290 244 297 16.643411 49.43093067 Reimeria sinuata 941921 SAR_Eukaryotes SAR_Eukaryotes 412 1.1e-110   NTclustered gi|357381817|gb|JN790292.1| 941921 g236 i0 92.734 97.3602693602694 289 9 97 3 8 296 7 283 Reimeria sinuata strain TCC721 18S ribosomal RNA gene, partial sequence blastn 28916 412 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Reimeria Reimeria sinuata
10113259 10113259 PRJNA702290_P_NODE_1928_length_155_cov_14.681034_g1920_i0 PRJNA702290 1928 155 14.681034 22.7556027 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 141 2.64e-29   NTclustered gi|66571041|emb|AJ878467.1| 29204 g1920 i0 98.734 96.258064516129 79 1 95 0 2 80 193 271 Cyclotella cryptica partial 28S rRNA gene, strain CCMP 331 blastn 14920 141 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
21086163 21086163 PRJNA702290_P_NODE_517_length_198_cov_15.610063_g509_i0 PRJNA702290 517 198 15.610063 30.90792474 Discostella sp. 2728207 SAR_Eukaryotes SAR_Eukaryotes 348 1.95e-91   NTclustered gi|2632235294|gb|OR922676.1| 2728207 g509 i0 98.969 97.9545454545455 194 2 98 0 3 196 3571 3764 Discostella sp. strain AGSB0027 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 19395 348 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella sp.
21086165 21086165 PRJNA702290_P_NODE_557_length_192_cov_2.882353_g549_i0 PRJNA702290 557 192 2.882353 5.53411776 uncultured stramenopile 152704 SAR_Eukaryotes SAR_Eukaryotes 141 3.43e-29   NTclustered gi|385663507|gb|JQ782061.1| 152704 g549 i0 100 50.0364583333333 76 0 73 0 115 190 457 532 Uncultured stramenopile clone 14H3Te6L1 18S ribosomal RNA gene, partial sequence blastn 9607 141 1 Eukaryota Sar             uncultured stramenopile
21086167 21086167 PRJNA702290_P_NODE_597_length_191_cov_22.243421_g589_i0 PRJNA702290 597 191 22.243421 42.48493411 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 95.9 3.18e-21   NR KAL3804087.1 29204 g589 i0 78.7 24.9267015706806 61 13 95.8 0 187 5 177 237 KAL3804087.1 hypothetical protein HJC23_006478 [Cyclotella cryptica] diamond 4761 96.3 0.995846313603323 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
21586898 21586898 PRJNA702290_P_NODE_237_length_302_cov_7.619772_g229_i0 PRJNA702290 237 302 7.619772 23.01171144 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 135 2.71e-27   NTclustered gi|2739942905|dbj|LC814765.1| 2843 g229 i0 100 122.37417218543 73 0 74 0 223 295 4059 3987 Skeletonema costatum SCHP35 chloroplast DNA, complete genome blastn 36957 135 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum
26861635 26861635 PRJNA702290_P_NODE_1821_length_156_cov_28.358974_g1813_i0 PRJNA702290 1821 156 28.358974 44.23999944 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 81.3 2.95e-16   NR KAG7372249.1 303405 g1813 i0 73.2 1.07692307692308 56 7 92.3 1 9 152 71 126 KAG7372249.1 myosin E [Nitzschia inconspicua] diamond 168 81.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27367579 27367579 PRJNA702290_P_NODE_1903_length_155_cov_25.741379_g1895_i0 PRJNA702290 1903 155 25.741379 39.89913745 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 53.5 6.38e-7   NR CAB9509387.1 568900 g1895 i0 96 0.483870967741935 25 1 48.4 0 80 154 58 82 CAB9509387.1 expressed unknown protein [Seminavis robusta] diamond 75 53.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29072459 29072459 PRJNA702290_P_NODE_828_length_191_cov_12.111842_g820_i0 PRJNA702290 828 191 12.111842 23.13361822 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 50.8 2.54e-5   NR KAG7338604.1 303405 g820 i0 100 2.26178010471204 24 0 37.7 0 7 78 237 260 KAG7338604.1 ATP synthase F1 subunit gamma [Nitzschia inconspicua] diamond 432 50.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua

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