RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA940501" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA940501 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
2195317 2195317 PRJNA940501_S_NODE_268362_length_174_cov_1.671756_g267544_i0 PRJNA940501 268362 174 1.671756 2.90885544 Chaetoceros olympicus 2809014 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.004   NTclustered gi|2862228902|gb|PQ645536.1| 2809014 g267544 i0 100 0.166666666666667 29 0 17 0 142 170 3700 3672 Chaetoceros olympicus isolate AGSB0412 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 29 54.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros olympicus
3469516 3469516 PRJNA940501_S_NODE_177363_length_200_cov_4.649682_g176545_i0 PRJNA940501 177363 200 4.649682 9.299364 Thalassionema sp. 2316510 SAR_Eukaryotes SAR_Eukaryotes 134 6.03e-27   NTclustered gi|2862228852|gb|PQ645486.1| 2316510 g176545 i0 83.66 31.51 153 14 76 8 49 200 3297 3155 Thalassionema sp. isolate AGSB0320 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 6302 134 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Thalassionemales Thalassionemataceae Thalassionema Thalassionema sp.
8910909 8910909 PRJNA940501_S_NODE_314307_length_164_cov_1.942149_g313489_i0 PRJNA940501 314307 164 1.942149 3.18512436 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 281 1.6000000000000001e-71   NTclustered gi|1538979133|gb|MH113811.1| 303400 g313489 i0 98.137 100.067073170732 161 3 98 0 4 164 9842 10002 Nitzschia palea chloroplast, complete genome blastn 16411 281 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
13671173 13671173 PRJNA940501_S_NODE_108971_length_232_cov_1.857143_g108153_i0 PRJNA940501 108971 232 1.857143 4.30857176 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.021   NTclustered gi|657012507|gb|KF302593.1| 2850 g108153 i0 100 0.120689655172414 28 0 12 0 1 28 202 175 Phaeodactylum tricornutum clone C780 transposase mRNA, complete cds blastn 28 52.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
14947061 14947061 PRJNA940501_S_NODE_209232_length_190_cov_1.537415_g208414_i0 PRJNA940501 209232 190 1.537415 2.9210885 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.001   NTclustered gi|657012507|gb|KF302593.1| 2850 g208414 i0 100 0.157894736842105 30 0 16 0 1 30 202 173 Phaeodactylum tricornutum clone C780 transposase mRNA, complete cds blastn 30 56.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
20045873 20045873 PRJNA940501_S_NODE_21296_length_356_cov_45.246006_g20478_i0 PRJNA940501 21296 356 45.246006 161.07578136 Minutocellus polymorphus 265543 SAR_Eukaryotes SAR_Eukaryotes 132 4.21e-26   NTclustered gi|2020303798|gb|MW417227.1| 265543 g20478 i0 78.404 3.34831460674157 213 38 59 7 42 250 8483 8691 Minutocellus polymorphus isolate CNS00217 mitochondrion, complete genome blastn 1192 132 1 Eukaryota Sar   Bacillariophyta Mediophyceae Cymatosirales Cymatosiraceae Minutocellus Minutocellus polymorphus
25484695 25484695 PRJNA940501_S_NODE_3420_length_985_cov_7.860934_g3067_i0 PRJNA940501 3420 985 7.860934 77.4301999 Haslea 67475 SAR_Eukaryotes SAR_Eukaryotes 213 4.33e-50   NTclustered gi|2722342554|gb|PP728232.1| 197759 g3067 i0 73.02 38.2862944162437 745 148 74 39 260 985 26071 26781 Haslea sp. strain P5 mitochondrion, complete genome blastn 37712 213 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea 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);;