RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA688931" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 9 ✖

tax_clade 1

bioproject 1

  • PRJNA688931 · 9 ✖

analysis 1

  • blastn · 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
8321532 8321532 PRJNA688931_P_NODE_14687_length_269_cov_3.181818_g14474_i0 PRJNA688931 14687 269 3.181818 8.55909042 Entomoneis umbratica 2086363 SAR_Eukaryotes SAR_Eukaryotes 475 1.2299999999999999e-129   NTclustered gi|2721954796|gb|OR464352.1| 2086363 g14474 i0 98.519 199.966542750929 270 3 100 1 1 269 73013 72744 Entomoneis umbratica plastid, complete genome blastn 53791 475 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis umbratica
13422427 13422427 PRJNA688931_P_NODE_31831_length_179_cov_1.261538_g31618_i0 PRJNA688931 31831 179 1.261538 2.25815302 Nitzschia reversa 2675857 SAR_Eukaryotes SAR_Eukaryotes 270 3.849999999999999e-68   NTclustered gi|2862228864|gb|PQ645498.1| 2675857 g31618 i0 93.855 16.0223463687151 179 11 100 0 1 179 3735 3913 Nitzschia reversa isolate AGSB0348 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 2868 270 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
14697488 14697488 PRJNA688931_P_NODE_33312_length_174_cov_1.664000_g33099_i0 PRJNA688931 33312 174 1.664 2.89536 Navicula incertata 2014769 SAR_Eukaryotes SAR_Eukaryotes 322 1.01e-83   NTclustered gi|2866543221|gb|PQ722531.1| 2014769 g33099 i0 100 199.028735632184 174 0 100 0 1 174 71856 72029 Navicula incertata chloroplast, complete genome blastn 34631 322 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula incertata
17246311 17246311 PRJNA688931_P_NODE_16914_length_249_cov_2.940000_g16701_i0 PRJNA688931 16914 249 2.94 7.3206 Pinnularia substreptoraphe 431580 SAR_Eukaryotes SAR_Eukaryotes 324 4.33e-84   NTclustered gi|183979100|emb|AM710592.1| 431580 g16701 i0 92.14 30.0682730923695 229 16 92 2 1 228 230 3 Pinnularia substreptoraphe partial 28S rRNA gene, strain AT-70.09 blastn 7487 324 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pinnulariaceae Pinnularia Pinnularia substreptoraphe
19795322 19795322 PRJNA688931_P_NODE_16216_length_255_cov_1.898058_g16003_i0 PRJNA688931 16216 255 1.898058 4.8400479 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 383 7.23e-102   NTclustered gi|146762526|gb|EF553458.1| 2850 g16003 i0 94.118 100.086274509804 255 10 100 4 1 255 3522 3771 Phaeodactylum tricornutum strain CCAP 1055/1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 25522 383 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
21070813 21070813 PRJNA688931_P_NODE_11677_length_306_cov_2.245136_g11464_i0 PRJNA688931 11677 306 2.245136 6.87011616 Pinnularia nodosa 445253 SAR_Eukaryotes SAR_Eukaryotes 442 1.4499999999999995e-119   NTclustered gi|1829658071|gb|MN319623.1| 445253 g11464 i0 95.956 91.3398692810458 272 11 89 0 1 272 272 1 Pinnularia nodosa voucher PIN885TM 28S ribosomal RNA gene, partial sequence blastn 27950 442 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pinnulariaceae Pinnularia Pinnularia nodosa
21580299 21580299 PRJNA688931_P_NODE_4617_length_518_cov_3.513859_g4406_i0 PRJNA688931 4617 518 3.513859 18.20178962 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 929 0   NTclustered gi|2866543221|gb|PQ722531.1| 2014769 g4406 i0 99.035 196.998069498069 518 5 100 0 1 518 73753 73236 Navicula incertata chloroplast, complete genome blastn 102045 929 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula incertata
24129961 24129961 PRJNA688931_P_NODE_24539_length_206_cov_1.923567_g24326_i0 PRJNA688931 24539 206 1.923567 3.96254802 Pinnularia 216736 SAR_Eukaryotes SAR_Eukaryotes 381 2.0199999999999994e-101   NTclustered gi|952988086|gb|KT072993.1| 431573 g24326 i0 100 100.043689320388 206 0 100 0 1 206 356 151 Pinnularia anglica isolate TCC701 18S ribosomal RNA gene, partial sequence blastn 20609 381 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pinnulariaceae Pinnularia Pinnularia anglica
24129962 24129962 PRJNA688931_P_NODE_2459_length_727_cov_4.393805_g2290_i0 PRJNA688931 2459 727 4.393805 31.94296235 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 1230 0   NTclustered gi|1803023461|gb|MN937452.1| 2850 g2290 i0 97.387 198.119669876204 727 12 100 1 1 727 68904 68185 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 144033 1232 0.998376623376623 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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