RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA889065", 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 · 8 ✖

tax_clade 1

bioproject 1

  • PRJNA889065 · 8 ✖

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
12342422 12342422 PRJNA889065_S_NODE_10130_length_300_cov_4.529183_g9892_i0 PRJNA889065 10130 300 4.529183 13.587549 Minutocellus polymorphus 265543 SAR_Eukaryotes SAR_Eukaryotes 126 1.62e-24   NTclustered gi|2020303798|gb|MW417227.1| 265543 g9892 i0 77.934 3.97333333333333 213 39 70 7 27 235 8483 8691 Minutocellus polymorphus isolate CNS00217 mitochondrion, complete genome blastn 1192 126 1 Eukaryota Sar   Bacillariophyta Mediophyceae Cymatosirales Cymatosiraceae Minutocellus Minutocellus polymorphus
27087176 27087176 PRJNA889065_S_NODE_11082_length_288_cov_2.253061_g10844_i0 PRJNA889065 11082 288 2.253061 6.48881568 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 65.1 1.41e-10   NR GFH50077.1 426638 g10844 i0 39.8 1.75 88 53 91.7 0 281 18 41 128 GFH50077.1 hypothetical protein CTEN210_06553 [Chaetoceros tenuissimus] diamond 504 65.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
27245108 27245108 PRJNA889065_S_NODE_29463_length_178_cov_1.022222_g29225_i0 PRJNA889065 29463 178 1.022222 1.81955516 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 50.4 2.76e-5   NR XP_002286556.1 296543 g29225 i0 33.9 0.943820224719101 56 37 94.4 0 169 2 225 280 XP_002286556.1 predicted protein, partial [Thalassiosira pseudonana CCMP1335] diamond 168 50.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
27340128 27340128 PRJNA889065_S_NODE_9723_length_306_cov_3.083650_g9485_i0 PRJNA889065 9723 306 3.08365 9.435969 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 55.1 3.84e-6   NR KAI2501635.1 210448 g9485 i0 40.6 0.676470588235294 69 39 67.6 1 16 222 1009 1075 KAI2501635.1 hypothetical protein MHU86_12833 [Fragilaria crotonensis] diamond 207 55.1 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27466467 27466467 PRJNA889065_S_NODE_15423_length_247_cov_2.254902_g15185_i0 PRJNA889065 15423 247 2.254902 5.56960794 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 53.1 8.32e-6   NR KAL3788617.1 382360 g15185 i0 53.3 0.983805668016194 45 21 54.7 0 163 29 254 298 KAL3788617.1 hypothetical protein ACHAWO_011833 [Cyclotella atomus] diamond 243 53.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
29771051 29771051 PRJNA889065_S_NODE_15851_length_244_cov_1.815920_g15613_i0 PRJNA889065 15851 244 1.81592 4.4308448 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 73.2 7.01e-13   NR KAL3922776.1 3061772 g15613 i0 48.8 0.983606557377049 80 36 98.4 1 242 3 678 752 KAL3922776.1 MAG: hypothetical protein SGILL_002022, partial [Bacillariaceae sp.] diamond 240 73.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30876970 30876970 PRJNA889065_S_NODE_27874_length_183_cov_2.628571_g27636_i0 PRJNA889065 27874 183 2.628571 4.81028493 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 50.4 3.24e-5   NR KAG7349198.1 303405 g27636 i0 64.5 1.0327868852459 31 11 50.8 0 7 99 437 467 KAG7349198.1 glycine hydroxymethyltransferase [Nitzschia inconspicua] diamond 189 50.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31327245 31327245 PRJNA889065_S_NODE_8635_length_324_cov_1.512456_g8397_i0 PRJNA889065 8635 324 1.512456 4.90035744 root 1 Root_unresolved Root_unresolved 62 1.62e-8   NR GFH59123.1 426638 g8397 i0 39.5 2.30555555555556 76 46 70.4 0 5 232 562 637 GFH59123.1 chaperone, heat shock protein 70 [Chaetoceros tenuissimus] diamond 747 62.4 0.993589743589744 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus

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