RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA1160211" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 13 ✖

tax_clade 1

bioproject 1

  • PRJNA1160211 · 13 ✖

analysis 1

  • blastn · 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
310292 310292 PRJNA1160211_S_NODE_28501_length_659_cov_14.247440_g27410_i0 PRJNA1160211 28501 659 14.24744 93.8906296 Hantzschia amphioxys 186034 SAR_Eukaryotes SAR_Eukaryotes 1081 0   NTclustered gi|18698476|gb|AF417677.1| 186034 g27410 i0 98.847 91.587253414264 607 6 92 1 1 606 607 1 Hantzschia amphioxys strain UTEX657 large subunit ribosomal RNA gene, partial sequence blastn 60356 1081 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Hantzschia Hantzschia amphioxys
310810 310810 PRJNA1160211_S_NODE_81441_length_495_cov_5.691943_g80224_i0 PRJNA1160211 81441 495 5.691943 28.17511785 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 244 7.429999999999999e-60   NTclustered gi|2074156200|gb|MW413905.1| 216802 g80224 i0 79.088 70.7777777777778 373 64 74 11 117 483 24156 24520 Guinardia delicatula mitochondrion, complete genome blastn 35035 244 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
3589070 3589070 PRJNA1160211_S_NODE_230223_length_279_cov_4.466019_g228990_i0 PRJNA1160211 230223 279 4.466019 12.46019301 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 435 2.18e-117   NTclustered gi|662012663|ref|NC_024082.1| 2856 g228990 i0 97.266 182.591397849462 256 7 92 0 24 279 94013 94268 Cylindrotheca closterium chloroplast, complete genome blastn 50943 435 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
7416266 7416266 PRJNA1160211_S_NODE_169906_length_347_cov_5.175182_g168673_i0 PRJNA1160211 169906 347 5.175182 17.95788154 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 320 8.16e-83   NTclustered gi|725539117|gb|KM407590.1| 1574083 g168673 i0 85.266 20.6311239193084 319 37 90 8 1 312 316 1 Luticola muticopsis f. capitata isolate Ant003-G11 28S ribosomal RNA gene, partial sequence blastn 7159 320 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Diadesmidaceae Luticola Luticola muticopsis
7416960 7416960 PRJNA1160211_S_NODE_83126_length_491_cov_25.198565_g81907_i0 PRJNA1160211 83126 491 25.198565 123.72495415 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 191 9.73e-44   NTclustered gi|1419234446|dbj|AP018505.1| 2083271 g81907 i0 75 21.0264765784114 468 90 92 22 22 472 1476 1933 Nitzschia sp. PL3-2 mitochondrial DNA, nearly complete genome blastn 10324 191 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. PL3-2
9237205 9237205 PRJNA1160211_S_NODE_142268_length_386_cov_2.741214_g141035_i0 PRJNA1160211 142268 386 2.741214 10.58108604 Haslea pseudostrearia 197756 SAR_Eukaryotes SAR_Eukaryotes 481 3.97e-131   NTclustered gi|2328348073|ref|NC_067581.1| 197756 g141035 i0 90.244 105.170984455959 369 35 95 1 1 368 40716 40348 Haslea pseudostrearia strain SCCAP K-1594 chloroplast, complete genome blastn 40596 481 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea pseudostrearia
9237317 9237317 PRJNA1160211_S_NODE_156428_length_365_cov_39.458904_g155195_i0 PRJNA1160211 156428 365 39.458904 144.0249996 Helicotheca tamesis 374047 SAR_Eukaryotes SAR_Eukaryotes 163 1.53e-35   NTclustered gi|2202538970|gb|OM891876.1| 374047 g155195 i0 77.58 61.3890410958904 281 56 76 7 1 276 4305 4583 Helicotheca tamesis 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 22407 163 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Helicotheca Helicotheca tamesis
15611858 15611858 PRJNA1160211_S_NODE_120913_length_419_cov_27.210983_g119684_i0 PRJNA1160211 120913 419 27.210983 114.01401877 Haslea pseudostrearia 197756 SAR_Eukaryotes SAR_Eukaryotes 158 8.31e-34   NTclustered gi|2328347954|ref|NC_067578.1| 197756 g119684 i0 76.106 14.0238663484487 339 59 79 17 17 348 27587 27910 Haslea pseudostrearia strain SCCAP K-1594 mitochondrion, complete genome blastn 5876 158 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea pseudostrearia
15612689 15612689 PRJNA1160211_S_NODE_229293_length_280_cov_3.594203_g228060_i0 PRJNA1160211 229293 280 3.594203 10.0637684 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 340 4.919999999999999e-89   NTclustered gi|2059418728|gb|MW971521.1| 303405 g228060 i0 90.076 52.7678571428571 262 26 94 0 19 280 39964 40225 Nitzschia inconspicua strain hildebrandi mitochondrion, complete genome blastn 14775 340 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
19434982 19434982 PRJNA1160211_S_NODE_107576_length_443_cov_2.159459_g106348_i0 PRJNA1160211 107576 443 2.159459 9.56640337 Schizostauron trachyderma 2770866 SAR_Eukaryotes SAR_Eukaryotes 187 1.13e-42   NTclustered gi|2125739626|gb|MZ520767.1| 2770866 g106348 i0 82.857 2.25733634311512 210 34 47 2 5 213 26978 27186 Schizostauron trachyderma strain SZCZE1420 mitochondrion, complete genome blastn 1000 187 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Schizostauron Schizostauron trachyderma
21985823 21985823 PRJNA1160211_S_NODE_119158_length_422_cov_14.790831_g117929_i0 PRJNA1160211 119158 422 14.790831 62.41730682 Nitzschia sp. (in: diatoms) 1884248 SAR_Eukaryotes SAR_Eukaryotes 691 0   NTclustered gi|2862228875|gb|PQ645509.1| 1884248 g117929 i0 96.209 100.575829383886 422 16 100 0 1 422 3550 3971 Nitzschia sp. (in: diatoms) isolate AGSB0363 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 42443 691 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. (in: diatoms)
24534975 24534975 PRJNA1160211_S_NODE_107140_length_443_cov_30.624324_g105912_i0 PRJNA1160211 107140 443 30.624324 135.66575532 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 747 0   NTclustered gi|1803023461|gb|MN937452.1| 2850 g105912 i0 98.807 186.819413092551 419 5 95 0 24 442 68173 68591 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 82761 747 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
24535042 24535042 PRJNA1160211_S_NODE_113460_length_432_cov_12.175487_g112231_i0 PRJNA1160211 113460 432 12.175487 52.59810384 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 339 2.86e-88   NTclustered gi|657012566|gb|KF302620.1| 2850 g112231 i0 88.732 91.9444444444444 284 22 65 9 154 432 870 592 Phaeodactylum tricornutum clone C821 hypothetical protein mRNA, complete cds blastn 39720 339 1 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);;