RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA942359" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 12 ✖

tax_clade 1

bioproject 1

  • PRJNA942359 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
922793 922793 PRJNA942359_P_NODE_10161_length_279_cov_1.398058_g10046_i0 PRJNA942359 10161 279 1.398058 3.90058182 Haslea sp. 197759 SAR_Eukaryotes SAR_Eukaryotes 128 4.15e-25   NTclustered gi|2722342554|gb|PP728232.1| 197759 g10046 i0 88.679 3.55913978494624 106 11 38 1 126 230 28387 28282 Haslea sp. strain P5 mitochondrion, complete genome blastn 993 128 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea sp.
923104 923104 PRJNA942359_P_NODE_6901_length_324_cov_1.243028_g6786_i0 PRJNA942359 6901 324 1.243028 4.02741072 Witkowskia abiskoensis 1574455 SAR_Eukaryotes SAR_Eukaryotes 542 1.48e-149   NTclustered gi|725655293|gb|KJ011733.1| 1574455 g6786 i0 96.904 108.555555555556 323 10 99 0 2 324 475 153 Placoneis abiskoensis strain FD363 photosystem II reaction center protein D1 (psbA) gene, partial cds; chloroplast blastn 35172 542 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Witkowskiaceae Witkowskia Witkowskia abiskoensis
2198256 2198256 PRJNA942359_P_NODE_15602_length_249_cov_0.886364_g15487_i0 PRJNA942359 15602 249 0.886364 2.20704636 Mayamaea permitis 1302819 SAR_Eukaryotes SAR_Eukaryotes 412 8.97e-111   NTclustered gi|2163362270|dbj|LC648446.1| 1302819 g15487 i0 96.774 99.6987951807229 248 7 99 1 2 249 1099 853 Mayamaea permitis NIES-2724 chloroplast gene for ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit, partial cds blastn 24825 412 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea permitis
3473819 3473819 PRJNA942359_P_NODE_20223_length_242_cov_0.923077_g20108_i0 PRJNA942359 20223 242 0.923077 2.23384634 Halamphora sp. 1951536 SAR_Eukaryotes SAR_Eukaryotes 353 5.34e-93   NTclustered gi|2749492174|gb|PP727123.1| 1951536 g20108 i0 93.305 11.1446280991736 239 16 99 0 1 239 84769 85007 Halamphora sp. strain SZCZEY 2167 chloroplast, complete genome blastn 2697 353 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora sp.
4751416 4751416 PRJNA942359_P_NODE_20484_length_235_cov_2.888889_g20369_i0 PRJNA942359 20484 235 2.888889 6.78888915 Halamphora calidilacuna 2133758 SAR_Eukaryotes SAR_Eukaryotes 182 2.57e-41   NTclustered gi|1372147719|gb|MF997424.1| 2133758 g20369 i0 81.197 1.68936170212766 234 37 98 7 2 231 59801 59571 Halamphora calidilacuna mitochondrion, complete genome blastn 397 182 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora calidilacuna
11126758 11126758 PRJNA942359_P_NODE_769_length_866_cov_1.388398_g676_i0 PRJNA942359 769 866 1.388398 12.02352668 Halamphora sp. 1951536 SAR_Eukaryotes SAR_Eukaryotes 953 0   NTclustered gi|2751573237|gb|PP962257.1| 1951536 g676 i0 87.681 97.5958429561201 828 90 95 9 41 866 30408 31225 Halamphora sp. strain SZCZEY 2167 mitochondrion, complete genome blastn 84518 953 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora sp.
17501313 17501313 PRJNA942359_P_NODE_7434_length_314_cov_2.103734_g7319_i0 PRJNA942359 7434 314 2.103734 6.60572476 Tryblionella apiculata 1003145 SAR_Eukaryotes SAR_Eukaryotes 274 5.759999999999998e-69   NTclustered gi|2088232767|ref|NC_056792.1| 1003145 g7319 i0 82.769 2.29299363057325 325 39 100 14 1 314 37026 37344 Tryblionella apiculata isolate SZCZR1825 mitochondrion, complete genome blastn 720 274 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Tryblionella Tryblionella apiculata
18774871 18774871 PRJNA942359_P_NODE_6035_length_342_cov_2.877323_g5920_i0 PRJNA942359 6035 342 2.877323 9.84044466 Halamphora montana 97221 SAR_Eukaryotes SAR_Eukaryotes 627 4.22e-175   NTclustered gi|1143637947|gb|KX120341.1| 1951535 g5920 i0 99.708 100.111111111111 343 0 100 1 1 342 358 16 Halamphora montana isolate L1327 28S ribosomal RNA gene, partial sequence blastn 34238 627 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora montana
19110145 19110145 PRJNA942359_P_NODE_11195_length_268_cov_2.543590_g11080_i0 PRJNA942359 11195 268 2.54359 6.8168212 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 422 1.62e-113   NTclustered gi|2328365172|ref|NC_067848.1| 97227 g11080 i0 95.167 194.75 269 9 100 4 1 268 70832 70567 Gomphonema parvulum voucher personal collection:A.Bruce Cahoon:diatom-2021-A chloroplast, complete genome blastn 52193 425 0.992941176470588 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
21324893 21324893 PRJNA942359_P_NODE_1017_length_761_cov_6.405523_g914_i0 PRJNA942359 1017 761 6.405523 48.74603003 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 1064 0   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g914 i0 91.995 96.2785808147175 762 56 100 4 1 761 4072 4829 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 73268 1064 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
25149235 25149235 PRJNA942359_P_NODE_1960_length_557_cov_2.832645_g1846_i0 PRJNA942359 1960 557 2.832645 15.77783265 Halamphora calidilacuna 2133758 SAR_Eukaryotes SAR_Eukaryotes 723 0   NTclustered gi|1372147719|gb|MF997424.1| 2133758 g1846 i0 90.27 72.7253141831239 555 50 99 4 5 557 63238 62686 Halamphora calidilacuna mitochondrion, complete genome blastn 40508 723 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora calidilacuna
25149295 25149295 PRJNA942359_P_NODE_4120_length_399_cov_2.180982_g4005_i0 PRJNA942359 4120 399 2.180982 8.70211818 Halamphora sp. 1951536 SAR_Eukaryotes SAR_Eukaryotes 370 9.29e-98   NTclustered gi|2751573237|gb|PP962257.1| 1951536 g4005 i0 86.167 49.6967418546366 347 42 86 6 4 346 29694 29350 Halamphora sp. strain SZCZEY 2167 mitochondrion, complete genome blastn 19829 370 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora 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);;