RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA753704" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA753704 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
2477507 2477507 PRJNA753704_P_NODE_31482_length_197_cov_8.895161_g31121_i0 PRJNA753704 31482 197 8.895161 17.52346717 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 364 1.929999999999999e-96   NTclustered gi|168145917|emb|AM710568.1| 431397 g31121 i0 100 99.9695431472081 197 0 100 0 1 197 106 302 Navicula capitatoradiata partial 28S rRNA gene, strain AT-212Gel07 blastn 19694 364 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula capitatoradiata
3282286 3282286 PRJNA753704_P_NODE_15183_length_308_cov_1.025532_g14822_i0 PRJNA753704 15183 308 1.025532 3.15863856 Skeletonema menzelii 216823 SAR_Eukaryotes SAR_Eukaryotes 424 5.29e-114   NTclustered gi|2739942921|dbj|LC814781.1| 216823 g14822 i0 91.613 82.3701298701299 310 20 100 6 1 308 33660 33965 Skeletonema menzelii NIES-2842 mitochondrial DNA, complete genome blastn 25370 424 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema menzelii
3753719 3753719 PRJNA753704_P_NODE_15143_length_308_cov_2.093617_g14782_i0 PRJNA753704 15143 308 2.093617 6.44834036 root 1 Root_unresolved Root_unresolved 110 1.68e-19   NTclustered gi|2589355395|ref|NC_077461.1| 29204 g14782 i0 87.368 60.237012987013 95 12 31 0 212 306 70119 70025 Cyclotella cryptica chloroplast, complete genome blastn 18553 110 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
4559422 4559422 PRJNA753704_P_NODE_15304_length_306_cov_7.257511_g14943_i0 PRJNA753704 15304 306 7.257511 22.20798366 Didymosphenia geminata 1115533 SAR_Eukaryotes SAR_Eukaryotes 560 3.84e-155   NTclustered gi|662012825|ref|NC_024083.1| 1115533 g14943 i0 99.673 198 306 1 100 0 1 306 67906 68211 Didymosphenia geminata chloroplast, complete genome blastn 60588 560 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Didymosphenia Didymosphenia geminata
9659634 9659634 PRJNA753704_P_NODE_29288_length_235_cov_2.623457_g28927_i0 PRJNA753704 29288 235 2.623457 6.16512395 Nitzschia laevis 186029 SAR_Eukaryotes SAR_Eukaryotes 200 7.11e-47   NTclustered gi|1581445387|gb|MH017309.1| 186029 g28927 i0 87.719 44.6085106382979 171 21 73 0 55 225 431 601 Nitzschia laevis isolate ccmp1092 NADH dehydrogenase subunit 1 (nad1) gene, partial cds; mitochondrial blastn 10483 200 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia laevis
10935031 10935031 PRJNA753704_P_NODE_18169_length_283_cov_6.804762_g17808_i0 PRJNA753704 18169 283 6.804762 19.25747646 Brebissonia lanceolata 487518 SAR_Eukaryotes SAR_Eukaryotes 523 4.5999999999999983e-144   NTclustered gi|168145930|emb|AM710582.1| 487518 g17808 i0 100 82.5441696113074 283 0 100 0 1 283 3 285 Cymbella lanceolata partial 28S rRNA gene, strain AT-194Gel07 blastn 23360 523 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Brebissonia Brebissonia lanceolata
16504987 16504987 PRJNA753704_P_NODE_2533_length_690_cov_3.570502_g2191_i0 PRJNA753704 2533 690 3.570502 24.6364638 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 113 3.11e-20   NTclustered gi|1169296927|gb|KY364697.1| 29204 g2191 i0 84.956 16.2478260869565 113 15 16 2 63 174 4458 4347 Cyclotella cryptica 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 11211 113 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
17309346 17309346 PRJNA753704_P_NODE_8594_length_398_cov_3.144615_g8233_i0 PRJNA753704 8594 398 3.144615 12.5155677 Pleurosigma inscriptura 2819025 SAR_Eukaryotes SAR_Eukaryotes 97.1 1.74e-15   NTclustered gi|2172612263|ref|NC_059753.1| 2819025 g8233 i0 81.301 0.992462311557789 123 19 30 4 266 386 5863 5743 Pleurosigma inscriptura isolate MEG005 mitochondrion, complete genome blastn 395 97.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pleurosigmataceae Pleurosigma Pleurosigma inscriptura
18583013 18583013 PRJNA753704_P_NODE_31175_length_204_cov_4.641221_g30814_i0 PRJNA753704 31175 204 4.641221 9.46809084 Haslea nusantara 2600302 SAR_Eukaryotes SAR_Eukaryotes 113 8.050000000000001e-21   NTclustered gi|1735238235|ref|NC_044491.1| 2600302 g30814 i0 77.957 3.16666666666667 186 37 90 4 21 204 56727 56544 Haslea nusantara chloroplast, complete genome blastn 646 113 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea nusantara
22879572 22879572 PRJNA753704_P_NODE_13578_length_323_cov_8.380000_g13217_i0 PRJNA753704 13578 323 8.38 27.0674 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 586 6.72e-163   NTclustered gi|2862228862|gb|PQ645496.1| 1923966 g13217 i0 99.381 100.393188854489 323 2 100 0 1 323 3727 3405 Navicula sp. isolate AGSB0345 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 32427 586 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.

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