RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "blastn", bioproject = "PRJNA928559" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 17 ✖

tax_clade 1

bioproject 1

  • PRJNA928559 · 17 ✖

analysis 1

  • blastn · 17 ✖

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
904613 904613 PRJNA928559_P_NODE_88341_length_378_cov_3.045902_g86772_i0 PRJNA928559 88341 378 3.045902 11.51350956 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 551 2.9099999999999986e-152   NTclustered gi|146762526|gb|EF553458.1| 2850 g86772 i0 93.531 98.7645502645503 371 22 98 2 5 374 4471 4102 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 37333 551 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
2528631 2528631 PRJNA928559_P_NODE_206902_length_245_cov_0.906977_g205333_i0 PRJNA928559 206902 245 0.906977 2.22209365 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 387 5.34e-103   NTclustered gi|2088232451|ref|NC_056789.1| 880757 g205333 i0 95.102 104.273469387755 245 12 100 0 1 245 8029 7785 Fistulifera saprophila isolate SZCZR1829 mitochondrion, complete genome blastn 25547 387 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera saprophila
2528903 2528903 PRJNA928559_P_NODE_90202_length_375_cov_1.380795_g88633_i0 PRJNA928559 90202 375 1.380795 5.17798125 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 148 4.429999999999999e-31   NTclustered gi|2862228903|gb|PQ645537.1| 216767 g88633 i0 81.868 53.2773333333333 182 28 48 5 101 280 3135 2957 Leptocylindrus minimus isolate AGSB0413 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 19979 148 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Leptocylindrales Leptocylindraceae Leptocylindrus Leptocylindrus minimus
6356816 6356816 PRJNA928559_P_NODE_159825_length_277_cov_91.950980_g158256_i0 PRJNA928559 159825 277 91.95098 254.7042146 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 451 2.15e-122   NTclustered gi|2325195844|gb|OM494341.1| 186043 g158256 i0 98.444 185.119133574007 257 3 93 1 1 257 89286 89031 Entomoneis sp. isolate C2 plastid, complete genome blastn 51278 451 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.
9830839 9830839 PRJNA928559_P_NODE_180528_length_258_cov_4.448649_g178959_i0 PRJNA928559 180528 258 4.448649 11.47751442 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 95.3 3.85e-15   NTclustered gi|2074156200|gb|MW413905.1| 216802 g178959 i0 77.647 25.0232558139535 170 29 64 8 77 240 23931 24097 Guinardia delicatula mitochondrion, complete genome blastn 6456 95.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
12382497 12382497 PRJNA928559_P_NODE_201130_length_247_cov_2.160920_g199561_i0 PRJNA928559 201130 247 2.16092 5.3374724 Pseudo-nitzschia galaxiae 189737 SAR_Eukaryotes SAR_Eukaryotes 84.2 7.92e-12   NTclustered gi|2852238308|gb|PQ498360.1| 189737 g199561 i0 75.12 15.5465587044534 209 37 82 11 26 227 33832 33632 Pseudo-nitzschia galaxiae isolate CNS01103 mitochondrion, complete genome blastn 3840 84.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia galaxiae
12383319 12383319 PRJNA928559_P_NODE_55330_length_464_cov_5.020460_g53764_i0 PRJNA928559 55330 464 5.02046 23.2949344 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 189 3.2899999999999992e-43   NTclustered gi|2074156200|gb|MW413905.1| 216802 g53764 i0 75.227 53.5064655172414 440 87 92 19 25 452 24698 24269 Guinardia delicatula mitochondrion, complete genome blastn 24827 189 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
13656133 13656133 PRJNA928559_P_NODE_137391_length_302_cov_1.860262_g135822_i0 PRJNA928559 137391 302 1.860262 5.61799124 Chaetoceros atlanticus 426624 SAR_Eukaryotes SAR_Eukaryotes 124 5.87e-24   NTclustered gi|2862228849|gb|PQ645483.1| 426624 g135822 i0 77.021 29.7317880794702 235 42 76 10 1 231 3586 3812 Chaetoceros atlanticus isolate AGSB0313 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 8979 124 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros atlanticus
13656305 13656305 PRJNA928559_P_NODE_150171_length_287_cov_3.135514_g148602_i0 PRJNA928559 150171 287 3.135514 8.99892518 Sundstroemia setigera 3005 SAR_Eukaryotes SAR_Eukaryotes 89.8 2.02e-13   NTclustered gi|9885790|gb|AF289048.1|AF289048 3005 g148602 i0 81.197 4.46689895470383 117 17 40 5 140 253 2687 2573 Rhizosolenia setigera internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 1282 89.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Sundstroemia Sundstroemia setigera
15281203 15281203 PRJNA928559_P_NODE_90492_length_374_cov_2.338870_g88923_i0 PRJNA928559 90492 374 2.33887 8.7473738 Sellaphora 216740 SAR_Eukaryotes SAR_Eukaryotes 656 0   NTclustered gi|134143232|gb|EF151962.1| 216741 g88923 i0 98.396 99.5187165775401 374 5 100 1 1 374 2 374 Sellaphora pupula clone RBG1 18S ribosomal RNA gene, partial sequence blastn 37220 662 0.990936555891239 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Sellaphoraceae Sellaphora Sellaphora pupula
16555415 16555415 PRJNA928559_P_NODE_196993_length_249_cov_1.267045_g195424_i0 PRJNA928559 196993 249 1.267045 3.15494205 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 237 5.8e-58   NTclustered gi|2162236522|gb|OL780377.1| 1561713 g195424 i0 88.776 74.3333333333333 196 18 78 4 1 194 330 137 Nitzschia commutata strain CBac2019039 large subunit ribosomal RNA gene, partial sequence blastn 18509 237 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia commutata
17830698 17830698 PRJNA928559_P_NODE_80294_length_395_cov_6.465839_g78725_i0 PRJNA928559 80294 395 6.465839 25.54006405 Skeletonema 2842 SAR_Eukaryotes SAR_Eukaryotes 137 1.01e-27   NTclustered gi|1179910904|dbj|LC258386.1| 371681 g78725 i0 88.696 29.0962025316456 115 10 29 3 31 144 2612 2724 Skeletonema grevillei genes for 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, strain: F35#9 blastn 11493 137 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema grevillei
18755815 18755815 PRJNA928559_P_NODE_64015_length_437_cov_1.994505_g62446_i0 PRJNA928559 64015 437 1.994505 8.71598685 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 174 8.64e-39   NTclustered gi|2156401020|dbj|LC537470.1| 426638 g62446 i0 75.879 48.8077803203661 398 65 87 25 8 389 32318 32700 Chaetoceros tenuissimus NIES-3715 mitochondrial DNA, complete genome blastn 21329 174 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
18756160 18756160 PRJNA928559_P_NODE_91975_length_371_cov_3.093960_g90406_i0 PRJNA928559 91975 371 3.09396 11.4785916 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 479 1.3699999999999996e-130   NTclustered gi|657012562|gb|KF302618.1| 2850 g90406 i0 90.107 95.822102425876 374 29 100 7 1 371 759 391 Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds blastn 35550 479 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
21655043 21655043 PRJNA928559_P_NODE_158857_length_278_cov_6.565854_g157288_i0 PRJNA928559 158857 278 6.565854 18.25307412 Entomoneis 186042 SAR_Eukaryotes SAR_Eukaryotes 492 1.27e-134   NTclustered gi|2325195844|gb|OM494341.1| 186043 g157288 i0 98.913 195.503597122302 276 2 99 1 3 278 90225 90499 Entomoneis sp. isolate C2 plastid, complete genome blastn 54350 492 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.
22580348 22580348 PRJNA928559_P_NODE_18998_length_725_cov_3.283742_g17546_i0 PRJNA928559 18998 725 3.283742 23.8071295 Helicotheca tamesis 374047 SAR_Eukaryotes SAR_Eukaryotes 169 6.9e-37   NTclustered gi|2202538970|gb|OM891876.1| 374047 g17546 i0 78.136 28.7462068965517 279 51 38 10 2 274 4309 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 20841 169 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Helicotheca Helicotheca tamesis
22930827 22930827 PRJNA928559_P_NODE_27038_length_623_cov_4.000000_g25524_i0 PRJNA928559 27038 623 4 24.92 Naviculaceae 67474 SAR_Eukaryotes SAR_Eukaryotes 219 5.76e-52   NTclustered gi|2277896764|dbj|AP026120.1| 1519565 g25524 i0 79.87 52.6195826645265 308 54 49 7 7 311 23430 23732 Fistulifera solaris JPCC DA0580 mitochondrial DNA, sequence_id:contig0001 blastn 32782 219 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris

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