RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA674050" 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

  • PRJNA674050 · 13 ✖

analysis 1

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
1919813 1919813 PRJNA674050_P_NODE_2362_length_444_cov_2.051213_g2159_i0 PRJNA674050 2362 444 2.051213 9.10738572 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 821 0   NTclustered gi|1803023461|gb|MN937452.1| 2850 g2159 i0 100 198.362612612613 444 0 100 0 1 444 67826 68269 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 88073 821 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
1920448 1920448 PRJNA674050_P_NODE_402_length_1153_cov_12.737963_g82_i5 PRJNA674050 402 1153 12.737963 146.86871339 Craticula sp. RGastineau-2025a 3393937 SAR_Eukaryotes SAR_Eukaryotes 117 4.1100000000000006e-21   NTclustered gi|2906190882|gb|PV031684.1| 3393937 g82 i5 76.316 10.3304423243712 228 49 20 4 683 907 63236 63461 Craticula sp. RGastineau-2025a strain SZCZEY2171 mitochondrion, complete genome blastn 11911 117 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Craticula Craticula sp. RGastineau-2025a
3718009 3718009 PRJNA674050_P_NODE_18123_length_264_cov_4.078534_g17920_i0 PRJNA674050 18123 264 4.078534 10.76732976 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 388 1.62e-103   NTclustered gi|2202538965|gb|OM891871.1| 515483 g17920 i0 93.561 101.257575757576 264 11 100 4 1 264 4801 5058 Psammodictyon constrictum 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 26732 388 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Psammodictyon Psammodictyon constrictum
4994589 4994589 PRJNA674050_P_NODE_19064_length_261_cov_4.872340_g18861_i0 PRJNA674050 19064 261 4.87234 12.7168074 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 472 1.54e-128   NTclustered gi|1803023461|gb|MN937452.1| 2850 g18861 i0 99.234 199 261 2 100 0 1 261 69466 69206 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 51939 472 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
5747999 5747999 PRJNA674050_P_NODE_885_length_722_cov_5.073960_g705_i0 PRJNA674050 885 722 5.07396 36.6339912 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 1334 0   NTclustered gi|18698480|gb|AF417681.1| 2850 g705 i0 100 97.1024930747922 722 0 100 0 1 722 750 29 Phaeodactylum tricornutum strain CCMP1327 large subunit ribosomal RNA gene, partial sequence blastn 70108 1334 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
11369822 11369822 PRJNA674050_P_NODE_13089_length_283_cov_4.485714_g12886_i0 PRJNA674050 13089 283 4.485714 12.69457062 Phaeodactylum 2849 SAR_Eukaryotes SAR_Eukaryotes 521 1.6599999999999996e-143   NTclustered gi|359385096|emb|FR865507.1| 2850 g12886 i0 100 99.5265017667844 282 0 99 0 1 282 72 353 Phaeodactylum tricornutum genomic DNA containing 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, culture collection CCAP 1055/3 blastn 28166 521 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
12645683 12645683 PRJNA674050_P_NODE_40830_length_234_cov_4.422360_g40627_i0 PRJNA674050 40830 234 4.42236 10.3483224 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 278 3.18e-70   NTclustered gi|2839792210|gb|PQ512808.1| 44447 g40627 i0 88.889 72.3931623931624 234 14 100 6 1 234 5533 5754 Pseudo-nitzschia delicatissima isolate CNS00130 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 16940 278 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia delicatissima
13397387 13397387 PRJNA674050_P_NODE_12611_length_285_cov_2.952830_g12408_i0 PRJNA674050 12611 285 2.95283 8.4155655 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 525 1.2899999999999994e-144   NTclustered gi|1803023461|gb|MN937452.1| 2850 g12408 i0 100 196.582456140351 284 0 99 0 1 284 68336 68619 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 56026 525 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
14673378 14673378 PRJNA674050_P_NODE_41032_length_232_cov_2.660377_g40829_i0 PRJNA674050 41032 232 2.660377 6.17207464 Hemiaulus sinensis 1003062 SAR_Eukaryotes SAR_Eukaryotes 167 7.1e-37   NTclustered gi|2248495916|ref|NC_063458.1| 1003062 g40829 i0 80 10.2715517241379 230 43 98 3 4 231 22132 21904 Hemiaulus sinensis isolate Qingdao in China mitochondrion, complete genome blastn 2383 167 1 Eukaryota Sar   Bacillariophyta Mediophyceae Hemiaulales Hemiaulaceae Hemiaulus Hemiaulus sinensis
17222035 17222035 PRJNA674050_P_NODE_31354_length_246_cov_2.254335_g31151_i0 PRJNA674050 31354 246 2.254335 5.5456641 Nitzschia traheaformis 1881117 SAR_Eukaryotes SAR_Eukaryotes 95.3 3.64e-15   NTclustered gi|2073953246|gb|MW849269.1| 1881117 g31151 i0 75.097 16.4552845528455 257 37 99 15 2 246 46395 46636 Nitzschia traheaformis isolate Qingdao in China mitochondrion, complete genome blastn 4048 95.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia traheaformis
17744222 17744222 PRJNA674050_P_NODE_21314_length_254_cov_8.679558_g21111_i0 PRJNA674050 21314 254 8.679558 22.04607732 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 466 6.95e-127   NTclustered gi|146762526|gb|EF553458.1| 2850 g21111 i0 100 99.2007874015748 252 0 99 0 1 252 3598 3849 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 25197 466 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
19771372 19771372 PRJNA674050_P_NODE_8476_length_311_cov_2.226891_g8273_i0 PRJNA674050 8476 311 2.226891 6.92563101 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 575 1.3899999999999995e-159   NTclustered gi|1803023461|gb|MN937452.1| 2850 g8273 i0 100 197.971061093248 311 0 100 0 1 311 69230 68920 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 61569 575 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
22320558 22320558 PRJNA674050_P_NODE_1058_length_657_cov_10.142123_g866_i0 PRJNA674050 1058 657 10.142123 66.63374811 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 1210 0   NTclustered gi|146762526|gb|EF553458.1| 2850 g866 i0 100 94.8249619482496 655 0 99 0 3 657 4724 4070 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 62300 1210 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);;