RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "blastn", bioproject = "PRJNA745553" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 32 ✖

tax_clade 1

bioproject 1

  • PRJNA745553 · 32 ✖

analysis 1

  • blastn · 32 ✖

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
724258 724258 PRJNA745553_S_NODE_2661_length_608_cov_3.112150_g2482_i0 PRJNA745553 2661 608 3.11215 18.921872 Fistulifera saprophila 880757 SAR_Eukaryotes SAR_Eukaryotes 911 0   NTclustered gi|2088232451|ref|NC_056789.1| 880757 g2482 i0 93.45 10.0197368421053 626 22 99 3 1 607 20023 19398 Fistulifera saprophila isolate SZCZR1829 mitochondrion, complete genome blastn 6092 911 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera saprophila
1198667 1198667 PRJNA745553_S_NODE_2961_length_590_cov_40.278530_g2778_i0 PRJNA745553 2961 590 40.27853 237.643327 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 1007 0   NTclustered gi|1419234739|dbj|AP018511.1| 303400 g2778 i0 98.264 193.850847457627 576 8 98 2 17 590 1375 800 Nitzschia palea NIES-2729 chloroplast DNA complet genome blastn 114372 1007 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
2000059 2000059 PRJNA745553_S_NODE_11962_length_354_cov_9.637011_g11767_i0 PRJNA745553 11962 354 9.637011 34.11501894 Epithemia pelagica 2809013 SAR_Eukaryotes SAR_Eukaryotes 141 6.95e-29   NTclustered gi|1973216564|gb|MW562875.1| 2809013 g11767 i0 91.346 29.4971751412429 104 7 29 2 159 261 193 295 Epithemia pelagica strain UHM3203 large subunit ribosomal RNA gene, partial sequence blastn 10442 141 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Rhopalodiales Rhopalodiaceae Epithemia Epithemia pelagica
3275628 3275628 PRJNA745553_S_NODE_28643_length_228_cov_3.787097_g28448_i0 PRJNA745553 28643 228 3.787097 8.63458116 Corethron sp. 2316512 SAR_Eukaryotes SAR_Eukaryotes 134 7.06e-27   NTclustered gi|2095587463|gb|OK147704.1| 2316512 g28448 i0 90.196 44.8157894736842 102 10 45 0 4 105 332 231 Corethron sp. strain HE492-01 large subunit ribosomal RNA gene, partial sequence blastn 10218 134 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Corethrales Corethraceae Corethron Corethron sp.
5827975 5827975 PRJNA745553_S_NODE_3745_length_553_cov_1.816667_g3560_i0 PRJNA745553 3745 553 1.816667 10.04616851 Nitzschia sp. DOCU1 3041873 SAR_Eukaryotes SAR_Eukaryotes 835 0   NTclustered gi|2504366780|emb|OX596003.1| 3041873 g3560 i0 93.874 190.490054249548 555 32 100 2 1 553 46719 46165 Nitzschia sp. DOCU1 genome assembly, organelle: plastid:chloroplast blastn 105341 835 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. DOCU1
5828027 5828027 PRJNA745553_S_NODE_5785_length_479_cov_2.945813_g5591_i0 PRJNA745553 5785 479 2.945813 14.11044427 Nitzschia sp. DOCU1 3041873 SAR_Eukaryotes SAR_Eukaryotes 603 1.03e-167   NTclustered gi|2504366780|emb|OX596003.1| 3041873 g5591 i0 89.979 96.4154488517745 469 43 97 4 7 472 34809 35276 Nitzschia sp. DOCU1 genome assembly, organelle: plastid:chloroplast blastn 46183 603 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. DOCU1
6302713 6302713 PRJNA745553_S_NODE_28065_length_232_cov_3.880503_g27870_i0 PRJNA745553 28065 232 3.880503 9.00276696 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 370 5.04e-98   NTclustered gi|146762526|gb|EF553458.1| 2850 g27870 i0 95.671 99.8362068965517 231 8 99 1 1 231 3805 3577 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 23162 372 0.99462365591397806 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
6302784 6302784 PRJNA745553_S_NODE_9945_length_384_cov_4.922830_g9750_i0 PRJNA745553 9945 384 4.92283 18.9036672 Ulnaria 426668 SAR_Eukaryotes SAR_Eukaryotes 577 4.8899999999999984e-160   NTclustered gi|2579686273|ref|NC_082433.1| 426669 g9750 i0 94.879 190.848958333333 371 16 96 3 1 368 66241 65871 Ulnaria ulna chloroplast, complete genome blastn 73286 582 0.991408934707904 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria ulna
7103013 7103013 PRJNA745553_S_NODE_29246_length_222_cov_4.389262_g29051_i0 PRJNA745553 29246 222 4.389262 9.74416164 Fistulifera saprophila 880757 SAR_Eukaryotes SAR_Eukaryotes 300 6.37e-77   NTclustered gi|2088232451|ref|NC_056789.1| 880757 g29051 i0 93.596 5.5045045045045 203 10 90 1 23 222 20168 20370 Fistulifera saprophila isolate SZCZR1829 mitochondrion, complete genome blastn 1222 300 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera saprophila
7103123 7103123 PRJNA745553_S_NODE_7426_length_435_cov_8.383978_g7231_i0 PRJNA745553 7426 435 8.383978 36.4703043 Amphipleura pellucida 1334924 SAR_Eukaryotes SAR_Eukaryotes 494 5.81e-135   NTclustered gi|817090633|gb|KM009376.1| 1334924 g7231 i0 89.141 96.0275862068966 396 43 91 0 19 414 1109 714 Amphipleura pellucida isolate ECT3568 PSI P700 apoprotein A1 (psaA) gene, partial cds; chloroplast blastn 41772 494 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Amphipleura Amphipleura pellucida
7576586 7576586 PRJNA745553_S_NODE_21406_length_267_cov_2.974227_g21211_i0 PRJNA745553 21406 267 2.974227 7.94118609 Fistulifera 880756 SAR_Eukaryotes SAR_Eukaryotes 488 1.5699999999999998e-133   NTclustered gi|2088232490|ref|NC_056790.1| 880757 g21211 i0 99.627 199.337078651685 268 0 100 1 1 267 71190 70923 Fistulifera saprophila isolate SZCZR1829 chloroplast, complete genome blastn 53223 488 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera saprophila
8377386 8377386 PRJNA745553_S_NODE_12327_length_349_cov_14.471014_g12132_i0 PRJNA745553 12327 349 14.471014 50.50383886 Stauroneis latistauros 1561715 SAR_Eukaryotes SAR_Eukaryotes 446 1.29e-120   NTclustered gi|725539124|gb|KM407597.1| 1561715 g12132 i0 92.138 94.5759312320917 318 21 90 1 2 315 318 1 Stauroneis latistauros isolate Ant007-H09 28S ribosomal RNA gene, partial sequence blastn 33007 446 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Stauroneis Stauroneis latistauros
9652609 9652609 PRJNA745553_S_NODE_19308_length_281_cov_5.168269_g19113_i0 PRJNA745553 19308 281 5.168269 14.52283589 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 392 1.3399999999999999e-104   NTclustered gi|2280443314|dbj|AP026159.1| 1519565 g19113 i0 94.163 11.220640569395 257 15 92 0 3 259 158234 157978 Fistulifera solaris JPCC DA0580 chloroplast DNA, sequence_id:contig0139 blastn 3153 392 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
10127363 10127363 PRJNA745553_S_NODE_27328_length_237_cov_4.762195_g27133_i0 PRJNA745553 27328 237 4.762195 11.28640215 Fistulifera 880756 SAR_Eukaryotes SAR_Eukaryotes 361 3.1099999999999996e-95   NTclustered gi|2088232490|ref|NC_056790.1| 880757 g27133 i0 97.196 180.160337552743 214 5 90 1 3 215 70247 70034 Fistulifera saprophila isolate SZCZR1829 chloroplast, complete genome blastn 42698 361 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera saprophila
10928138 10928138 PRJNA745553_S_NODE_18789_length_285_cov_1.816038_g18594_i0 PRJNA745553 18789 285 1.816038 5.1757083 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 315 3.039999999999999e-81   NTclustered gi|2633519340|gb|OR805654.1| 2126271 g18594 i0 88.213 41.2385964912281 263 31 92 0 23 285 17565 17827 Naviculales sp. strain SZCZO2114 plastid, complete genome blastn 11753 315 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
10928302 10928302 PRJNA745553_S_NODE_29349_length_220_cov_6.646259_g29154_i0 PRJNA745553 29349 220 6.646259 14.6217698 Fragilariopsis cylindrus 186039 SAR_Eukaryotes SAR_Eukaryotes 318 1.7399999999999995e-82   NTclustered gi|1783488149|ref|NC_045244.1| 186039 g29154 i0 95.477 177.477272727273 199 9 90 0 1 199 4505 4703 Fragilariopsis cylindrus chloroplast, complete genome blastn 39045 318 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
10928307 10928307 PRJNA745553_S_NODE_29549_length_217_cov_4.666667_g29354_i0 PRJNA745553 29549 217 4.666667 10.12666739 Nitzschia traheaformis 1881117 SAR_Eukaryotes SAR_Eukaryotes 87.9 5.25e-13   NTclustered gi|2073953246|gb|MW849269.1| 1881117 g29354 i0 77.326 2.88940092165899 172 23 78 7 20 189 46645 46488 Nitzschia traheaformis isolate Qingdao in China mitochondrion, complete genome blastn 627 87.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia traheaformis
12203825 12203825 PRJNA745553_S_NODE_3190_length_578_cov_6.033663_g3007_i0 PRJNA745553 3190 578 6.033663 34.87457214 Fistulifera saprophila 880757 SAR_Eukaryotes SAR_Eukaryotes 990 0   NTclustered gi|2088232451|ref|NC_056789.1| 880757 g3007 i0 98.743 33.6176470588235 557 7 96 0 1 557 5990 5434 Fistulifera saprophila isolate SZCZR1829 mitochondrion, complete genome blastn 19431 990 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera saprophila
12203955 12203955 PRJNA745553_S_NODE_950_length_780_cov_6.456860_g835_i0 PRJNA745553 950 780 6.45686 50.363508 Fistulifera saprophila 880757 SAR_Eukaryotes SAR_Eukaryotes 1376 0   NTclustered gi|2088232451|ref|NC_056789.1| 880757 g835 i0 99.089 105.005128205128 768 4 98 3 1 767 6920 6155 Fistulifera saprophila isolate SZCZR1829 mitochondrion, complete genome blastn 81904 1376 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera saprophila
12678365 12678365 PRJNA745553_S_NODE_5950_length_474_cov_3.825436_g5756_i0 PRJNA745553 5950 474 3.825436 18.13256664 Fistulifera 880756 SAR_Eukaryotes SAR_Eukaryotes 806 0   NTclustered gi|2088232451|ref|NC_056789.1| 880757 g5756 i0 98.472 95.8206751054852 458 6 96 1 17 473 9024 9481 Fistulifera saprophila isolate SZCZR1829 mitochondrion, complete genome blastn 45419 811 0.99383477188656 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera saprophila
13952600 13952600 PRJNA745553_S_NODE_1851_length_667_cov_13.787879_g1685_i0 PRJNA745553 1851 667 13.787879 91.96515293 Craticula 431342 SAR_Eukaryotes SAR_Eukaryotes 841 0   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g1685 i0 89.505 97.9640179910045 667 67 100 2 1 667 4903 4240 Naviculales sp. strain SZCZO2114 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 65342 841 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
14753034 14753034 PRJNA745553_S_NODE_18332_length_288_cov_6.637209_g18137_i0 PRJNA745553 18332 288 6.637209 19.11516192 Chaetoceros laevisporus 1937691 SAR_Eukaryotes SAR_Eukaryotes 76.8 1.58e-9   NTclustered gi|2043890831|gb|MZ267686.1| 1937691 g18137 i0 81.25 1.17361111111111 96 17 33 1 173 267 3105 3010 Chaetoceros laevisporus isolate CNS00396 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 338 76.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros laevisporus
14753037 14753037 PRJNA745553_S_NODE_18612_length_286_cov_3.370892_g18417_i0 PRJNA745553 18612 286 3.370892 9.64075112 Navicula veneta 138539 SAR_Eukaryotes SAR_Eukaryotes 451 2.23e-122   NTclustered gi|2088232843|ref|NC_056794.1| 138539 g18417 i0 95.105 54.5244755244755 286 14 100 0 1 286 114960 114675 Navicula veneta isolate SZCZR1826 chloroplast, complete genome blastn 15594 451 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula veneta
14753313 14753313 PRJNA745553_S_NODE_632_length_868_cov_15.569811_g538_i0 PRJNA745553 632 868 15.569811 135.14595948 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 1173 0   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g538 i0 91.139 97.8099078341014 869 72 100 4 1 868 4039 4903 Naviculales sp. strain SZCZO2114 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 84899 1173 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
16501610 16501610 PRJNA745553_S_NODE_17473_length_295_cov_3.527027_g17278_i0 PRJNA745553 17473 295 3.527027 10.40472965 Fistulifera 880756 SAR_Eukaryotes SAR_Eukaryotes 501 2.259999999999999e-137   NTclustered gi|2088232490|ref|NC_056790.1| 880757 g17278 i0 97.297 197.786440677966 296 6 100 2 1 295 71615 71321 Fistulifera saprophila isolate SZCZR1829 chloroplast, complete genome blastn 58347 501 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera saprophila
18575890 18575890 PRJNA745553_S_NODE_22615_length_260_cov_2.903743_g22420_i0 PRJNA745553 22615 260 2.903743 7.5497318 Fragilariopsis cylindrus 186039 SAR_Eukaryotes SAR_Eukaryotes 333 7.559999999999999e-87   NTclustered gi|1783488149|ref|NC_045244.1| 186039 g22420 i0 94.444 161.230769230769 216 12 83 0 23 238 4488 4703 Fragilariopsis cylindrus chloroplast, complete genome blastn 41920 333 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
20325123 20325123 PRJNA745553_S_NODE_23836_length_253_cov_2.366667_g23641_i0 PRJNA745553 23836 253 2.366667 5.98766751 Fistulifera 880756 SAR_Eukaryotes SAR_Eukaryotes 353 5.62e-93   NTclustered gi|2088232490|ref|NC_056790.1| 880757 g23641 i0 94.068 6.48221343873518 236 8 91 3 4 233 37248 37483 Fistulifera saprophila isolate SZCZR1829 chloroplast, complete genome blastn 1640 353 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera saprophila
21126692 21126692 PRJNA745553_S_NODE_16897_length_300_cov_4.612335_g16702_i0 PRJNA745553 16897 300 4.612335 13.837005 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 191 5.67e-44   NTclustered gi|657012566|gb|KF302620.1| 2850 g16702 i0 85.714 59.6833333333333 182 24 60 2 19 199 579 759 Phaeodactylum tricornutum clone C821 hypothetical protein mRNA, complete cds blastn 17905 191 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
23677336 23677336 PRJNA745553_S_NODE_29579_length_216_cov_6.615385_g29384_i0 PRJNA745553 29579 216 6.615385 14.2892316 Navicula veneta 138539 SAR_Eukaryotes SAR_Eukaryotes 361 2.79e-95   NTclustered gi|2088232843|ref|NC_056794.1| 138539 g29384 i0 100 177.148148148148 195 0 90 0 1 195 85424 85230 Navicula veneta isolate SZCZR1826 chloroplast, complete genome blastn 38264 361 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula veneta
24150320 24150320 PRJNA745553_S_NODE_29239_length_222_cov_4.637584_g29044_i0 PRJNA745553 29239 222 4.637584 10.29543648 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 324 3.78e-84   NTclustered gi|2301268953|ref|NC_066075.1| 355634 g29044 i0 96.02 171.702702702703 201 4 89 2 2 199 8694 8495 Navicula arenaria isolate Jiaozhou Bay in China chloroplast, complete genome blastn 38118 324 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria
24950845 24950845 PRJNA745553_S_NODE_29400_length_219_cov_11.527397_g29205_i0 PRJNA745553 29400 219 11.527397 25.24499943 Fragilariopsis kerguelensis 186038 SAR_Eukaryotes SAR_Eukaryotes 300 6.27e-77   NTclustered gi|1862846707|emb|LR812489.1| 186038 g29205 i0 93.97 91.3698630136986 199 10 90 2 22 219 7732 7929 Fragilariopsis kerguelensis, rDNA tandem repeat intergenic spacer region, 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2 and 28S ribosomal RNA gene, complete sequence blastn 20010 300 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis kerguelensis
25425237 25425237 PRJNA745553_S_NODE_1740_length_678_cov_7.433058_g1579_i0 PRJNA745553 1740 678 7.433058 50.39613324 Skeletonema 2842 SAR_Eukaryotes SAR_Eukaryotes 174 1.3799999999999999e-38   NTclustered gi|1179910904|dbj|LC258386.1| 371681 g1579 i0 92 18.3657817109145 125 8 18 2 404 527 2612 2735 Skeletonema grevillei genes for 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, strain: F35#9 blastn 12452 174 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema grevillei

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