RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where analysis = "blastn", bioproject = "PRJEB14175" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 29 ✖

tax_clade 1

bioproject 1

  • PRJEB14175 · 29 ✖

analysis 1

  • blastn · 29 ✖

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
25503481 25503481 PRJEB14175_P_NODE_15265_length_920_cov_106.734575_g13630_i0 PRJEB14175 15265 920 106.734575 981.95809 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 1306 0   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g13630 i0 92.645 100.075 911 61 99 6 11 920 4918 4013 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 92069 1306 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
25503596 25503596 PRJEB14175_P_NODE_155129_length_270_cov_19.392344_g152862_i0 PRJEB14175 155129 270 19.392344 52.3593288 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 111 4.03e-20   NTclustered gi|2633304248|gb|OR795084.1| 1923966 g152862 i0 83.333 1.26296296296296 126 16 46 5 1 123 8855 8732 Navicula sp. strain SZCZEY2262 mitochondrion, complete genome blastn 341 111 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
25505489 25505489 PRJEB14175_P_NODE_197161_length_230_cov_4.816568_g194894_i0 PRJEB14175 197161 230 4.816568 11.0781064 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 132 2.56e-26   NTclustered gi|313114|emb|Z23153.1| 2850 g194894 i0 82.051 3.71739130434783 156 26 69 2 21 175 825 979 P.tricornutum fcpE and fcpF genes, complete CDS's blastn 855 132 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
25505636 25505636 PRJEB14175_P_NODE_200737_length_227_cov_22.168675_g198470_i0 PRJEB14175 200737 227 22.168675 50.32289225 Schizostauron trachyderma 2770866 SAR_Eukaryotes SAR_Eukaryotes 274 3.96e-69   NTclustered gi|2125739626|gb|MZ520767.1| 2770866 g198470 i0 91.133 80.9911894273128 203 16 89 1 2 204 16392 16592 Schizostauron trachyderma strain SZCZE1420 mitochondrion, complete genome blastn 18385 274 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Schizostauron Schizostauron trachyderma
25639367 25639367 PRJEB14175_P_NODE_15266_length_920_cov_95.307334_g13630_i1 PRJEB14175 15266 920 95.307334 876.8274728 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 1234 0   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g13630 i1 91.228 100.008695652174 912 73 99 7 1 911 4013 4918 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 92008 1234 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
25743252 25743252 PRJEB14175_P_NODE_103722_length_349_cov_110866.027778_g101456_i0 PRJEB14175 103722 349 110866.027778 386922.43694522 Hantzschia 186033 SAR_Eukaryotes SAR_Eukaryotes 392 1.71e-104   NTclustered gi|725539095|gb|KM407568.1| 186034 g101456 i0 98.214 63.5243553008596 224 4 64 0 126 349 94 317 Hantzschia amphioxys isolate Ant025-E04 28S ribosomal RNA gene, partial sequence blastn 22170 392 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Hantzschia Hantzschia amphioxys
25774422 25774422 PRJEB14175_P_NODE_129235_length_305_cov_1.885246_g126968_i0 PRJEB14175 129235 305 1.885246 5.7500003 Haslea sp. 197759 SAR_Eukaryotes SAR_Eukaryotes 126 1.65e-24   NTclustered gi|2722342554|gb|PP728232.1| 197759 g126968 i0 88.785 1.54426229508197 107 7 34 3 35 137 28282 28387 Haslea sp. strain P5 mitochondrion, complete genome blastn 471 126 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea sp.
25776740 25776740 PRJEB14175_P_NODE_177163_length_247_cov_7.381720_g174896_i0 PRJEB14175 177163 247 7.38172 18.2328484 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 134 7.750000000000001e-27   NTclustered gi|219125331|ref|XM_002182901.1| 556484 g174896 i0 81.065 0.797570850202429 169 30 68 2 57 224 665 498 Phaeodactylum tricornutum CCAP 1055/1 protein fucoxanthin chlorophyll a/c protein (Lhcf8), mRNA blastn 197 134 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
25776755 25776755 PRJEB14175_P_NODE_177475_length_247_cov_2.741935_g175208_i0 PRJEB14175 177475 247 2.741935 6.77257945 Attheya longicornis 451786 SAR_Eukaryotes SAR_Eukaryotes 193 1.26e-44   NTclustered gi|1418587553|ref|NC_037999.1| 451786 g175208 i0 88.199 0.651821862348178 161 19 65 0 87 247 29323 29163 Attheya longicornis chloroplast, complete genome blastn 161 193 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Attheyaceae Attheya Attheya longicornis
25780520 25780520 PRJEB14175_P_NODE_270875_length_189_cov_2.500000_g268607_i0 PRJEB14175 270875 189 2.5 4.725 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 209 9.09e-50   NTclustered gi|657012566|gb|KF302620.1| 2850 g268607 i0 88.953 1.82010582010582 172 15 90 2 19 189 223 55 Phaeodactylum tricornutum clone C821 hypothetical protein mRNA, complete cds blastn 344 209 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
25783546 25783546 PRJEB14175_P_NODE_76771_length_418_cov_7.985994_g74511_i0 PRJEB14175 76771 418 7.985994 33.38145492 Nitzschia sp. LFS-2 1884248 SAR_Eukaryotes SAR_Eukaryotes 379 1.62e-100   NTclustered gi|725539113|gb|KM407586.1| 1574098 g74511 i0 86.022 26.2200956937799 372 30 89 14 49 418 1 352 Nitzschia sp. LFS-2014 isolate Ant015-G04 28S ribosomal RNA gene, partial sequence blastn 10960 379 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. LFS-2014
25880813 25880813 PRJEB14175_P_NODE_19963_length_818_cov_16.194188_g4473_i1 PRJEB14175 19963 818 16.194188 132.46845784 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 1280 0   NTclustered gi|2194766164|gb|OK505009.1| 2856 g4473 i1 95.539 195.623471882641 807 25 97 2 23 818 19686 20492 Cylindrotheca closterium chloroplast, complete genome blastn 160020 1280 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
25881339 25881339 PRJEB14175_P_NODE_227795_length_209_cov_0.864865_g225527_i0 PRJEB14175 227795 209 0.864865 1.80756785 Haslea 67475 SAR_Eukaryotes SAR_Eukaryotes 207 3.7e-49   NTclustered gi|2722342420|gb|PP728231.1| 197759 g225527 i0 86.082 113.842105263158 194 25 93 1 4 197 70480 70289 Haslea sp. strain P5 plastid, complete genome blastn 23793 207 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea sp.
25911349 25911349 PRJEB14175_P_NODE_146020_length_281_cov_1396.759091_g143753_i0 PRJEB14175 146020 281 1396.759091 3924.89304571 Minutocellus polymorphus 265543 SAR_Eukaryotes SAR_Eukaryotes 191 5.26e-44   NTclustered gi|2862228868|gb|PQ645502.1| 265543 g143753 i0 80.208 68.135231316726 288 29 100 18 1 281 4350 4084 Minutocellus polymorphus isolate AGSB0354 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 19146 191 1 Eukaryota Sar   Bacillariophyta Mediophyceae Cymatosirales Cymatosiraceae Minutocellus Minutocellus polymorphus
26018290 26018290 PRJEB14175_P_NODE_265276_length_195_cov_19.156716_g263008_i0 PRJEB14175 265276 195 19.156716 37.3555962 Trieres 1529381 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.017   NTclustered gi|2328368948|ref|NC_067955.1| 1335017 g263008 i0 100 0.287179487179487 28 0 14 0 139 166 52233 52206 Odontella regia chloroplast, complete genome blastn 56 52.8 1 Eukaryota Sar   Bacillariophyta Mediophyceae Eupodiscales Parodontellaceae Trieres Trieres regia
26018573 26018573 PRJEB14175_P_NODE_281732_length_164_cov_8.300971_g279464_i0 PRJEB14175 281732 164 8.300971 13.61359244 Naviculaceae 67474 SAR_Eukaryotes SAR_Eukaryotes 283 4.46e-72   NTclustered gi|42627634|emb|AJ544657.1| 913975 g279464 i0 97.605 101.737804878049 167 1 100 2 1 164 542 708 Navicula pelliculosa 18S rRNA gene and ITS1, strain SAG 1050-3 blastn 16685 283 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera pelliculosa
26046729 26046729 PRJEB14175_P_NODE_132149_length_300_cov_1719.686192_g129882_i0 PRJEB14175 132149 300 1719.686192 5159.058576 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 388 1.87e-103   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g129882 i0 90.753 88.8766666666667 292 25 97 2 1 291 4628 4918 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 26663 388 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
26049502 26049502 PRJEB14175_P_NODE_192757_length_234_cov_1.479769_g190490_i0 PRJEB14175 192757 234 1.479769 3.46265946 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 246 8.96e-61   NTclustered gi|2127869764|ref|NC_058701.1| 267567 g190490 i0 88.725 14.5897435897436 204 20 86 3 22 222 118635 118432 Skeletonema marinoi strain CNS00100 chloroplast, complete genome blastn 3414 246 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
26184566 26184566 PRJEB14175_P_NODE_165966_length_258_cov_15.233503_g163699_i0 PRJEB14175 165966 258 15.233503 39.30243774 Lithodesmium undulatum 59812 SAR_Eukaryotes SAR_Eukaryotes 217 7.87e-52   NTclustered gi|2202538968|gb|OM891874.1| 59812 g163699 i0 82.759 107.294573643411 261 27 100 13 1 258 4881 4636 Lithodesmium undulatum 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 27682 217 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Lithodesmium Lithodesmium undulatum
26192418 26192418 PRJEB14175_P_NODE_85142_length_394_cov_1.735736_g82877_i0 PRJEB14175 85142 394 1.735736 6.83879984 Gomphonema parvulum 97227 SAR_Eukaryotes SAR_Eukaryotes 152 3.61e-32   NTclustered gi|2328365145|ref|NC_067847.1| 97227 g82877 i0 81.622 1.44416243654822 185 32 46 2 204 386 23464 23280 Gomphonema parvulum voucher personal collection:A.Bruce Cahoon:diatom-2021-A mitochondrion, complete genome blastn 569 152 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
26289034 26289034 PRJEB14175_P_NODE_188694_length_237_cov_3.278409_g186427_i0 PRJEB14175 188694 237 3.278409 7.76982933 root 1 Root_unresolved Root_unresolved 62.1 3.53e-5   NTclustered gi|2194766164|gb|OK505009.1| 2856 g186427 i0 93.023 27.8649789029536 43 2 19 1 184 226 19040 19081 Cylindrotheca closterium chloroplast, complete genome blastn 6604 62.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
26321473 26321473 PRJEB14175_P_NODE_193743_length_233_cov_2.017442_g191476_i0 PRJEB14175 193743 233 2.017442 4.70063986 Craticula importuna 487666 SAR_Eukaryotes SAR_Eukaryotes 331 2.39e-86   NTclustered gi|168145897|emb|AM710533.1| 487666 g191476 i0 92.275 94.2360515021459 233 18 100 0 1 233 59 291 Craticula importuna partial 28S rRNA gene, strain AT-70Gel14a blastn 21957 331 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Craticula Craticula importuna
26324142 26324142 PRJEB14175_P_NODE_257327_length_201_cov_4.364286_g255059_i0 PRJEB14175 257327 201 4.364286 8.77221486 Halamphora sp. 1951536 SAR_Eukaryotes SAR_Eukaryotes 158 3.6e-34   NTclustered gi|2751573237|gb|PP962257.1| 1951536 g255059 i0 93.396 63.5273631840796 106 7 53 0 62 167 29480 29375 Halamphora sp. strain SZCZEY 2167 mitochondrion, complete genome blastn 12769 158 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora sp.
26324761 26324761 PRJEB14175_P_NODE_274079_length_182_cov_21.198347_g271811_i0 PRJEB14175 274079 182 21.198347 38.58099154 Cocconeiopsis kantsiensis 3082010 SAR_Eukaryotes SAR_Eukaryotes 104 4.21e-18   NTclustered gi|2692958369|ref|NC_086887.1| 3082010 g271811 i0 83.621 1.5989010989011 116 13 60 4 73 182 19002 18887 Cocconeiopsis kantsiensis isolate Huiquan Bay in China mitochondrion, complete genome blastn 291 104 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cocconeidales Cocconeidaceae Cocconeiopsis Cocconeiopsis kantsiensis
26328794 26328794 PRJEB14175_P_NODE_96015_length_366_cov_87.140984_g93749_i0 PRJEB14175 96015 366 87.140984 318.93600144 Psammothidium sp. LFS-2 1574099 SAR_Eukaryotes SAR_Eukaryotes 431 3.82e-116   NTclustered gi|725539122|gb|KM407595.1| 1574099 g93749 i0 91.693 85.7049180327869 313 22 85 4 5 315 324 14 Psammothidium sp. LFS-2014 isolate Ant022-H07 28S ribosomal RNA gene, partial sequence blastn 31368 431 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cocconeidales Achnanthidiaceae Psammothidium Psammothidium sp. LFS-2014
26423603 26423603 PRJEB14175_P_NODE_119087_length_321_cov_4.061538_g116821_i0 PRJEB14175 119087 321 4.061538 13.03753698 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 228 4.659999999999999e-55   NTclustered gi|2202538977|gb|OM891883.1| 1960768 g116821 i0 80.808 6.50778816199377 297 52 92 3 22 315 3905 4199 Pleurosigma sp. 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 2089 228 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pleurosigmataceae Pleurosigma Pleurosigma sp.
26426607 26426607 PRJEB14175_P_NODE_31263_length_665_cov_22.650662_g29164_i0 PRJEB14175 31263 665 22.650662 150.6269023 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 209 3.71e-49   NTclustered gi|1169296927|gb|KY364697.1| 29204 g29164 i0 96.094 26.3368421052632 128 5 28 0 216 343 4344 4471 Cyclotella cryptica 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 17514 209 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
26560741 26560741 PRJEB14175_P_NODE_179640_length_245_cov_2.625000_g177373_i0 PRJEB14175 179640 245 2.625 6.43125 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 71.3 6.11e-8   NTclustered gi|74325165|ref|NC_007405.1| 35128 g177373 i0 74.857 2.23673469387755 175 35 69 7 14 182 12497 12668 Thalassiosira pseudonana mitochondrion, complete genome blastn 548 71.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
26561380 26561380 PRJEB14175_P_NODE_212952_length_218_cov_5.974522_g210685_i0 PRJEB14175 212952 218 5.974522 13.02445796 Fragilariaceae 33856 SAR_Eukaryotes SAR_Eukaryotes 363 7.84e-96   NTclustered gi|2689771505|gb|PP420185.1| 210441 g210685 i0 98.095 119.412844036697 210 1 95 1 12 218 41 250 Asterionella formosa strain CCAC 3890 B large subunit ribosomal RNA gene, partial sequence; chloroplast blastn 26032 363 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionella Asterionella formosa

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