RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA846486" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 8 ✖

tax_clade 1

bioproject 1

  • PRJNA846486 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
4661702 4661702 PRJNA846486_P_NODE_49544_length_199_cov_1.020000_g49448_i0 PRJNA846486 49544 199 1.02 2.0298 Thalassiophysa hyalina 1953178 SAR_Eukaryotes SAR_Eukaryotes 58.4 3.71e-4   NTclustered gi|1143637949|gb|KX120343.1| 1953178 g49448 i0 100 0.155778894472362 31 0 16 0 164 194 199 229 Thalassiophysa hyalina isolate 4vi08.1cT 28S ribosomal RNA gene, partial sequence blastn 31 58.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Thalassiophysales Thalassiophysaceae Thalassiophysa Thalassiophysa hyalina
8486074 8486074 PRJNA846486_P_NODE_46127_length_204_cov_1.264516_g46031_i0 PRJNA846486 46127 204 1.264516 2.57961264 Leptocylindrus aporus 1398097 SAR_Eukaryotes SAR_Eukaryotes 86.1 1.75e-12   NTclustered gi|541134824|gb|KC814833.1| 1398097 g46031 i0 90.769 1.61274509803922 65 5 32 1 128 192 200 263 Leptocylindrus aporus strain SZN-B651 28S ribosomal RNA gene, partial sequence blastn 329 86.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Leptocylindrales Leptocylindraceae Leptocylindrus Leptocylindrus aporus
10159969 10159969 PRJNA846486_P_NODE_75368_length_169_cov_2.375000_g75272_i0 PRJNA846486 75368 169 2.375 4.01375 Entomoneis 186042 SAR_Eukaryotes SAR_Eukaryotes 226 7.859999999999997e-55   NTclustered gi|2202538958|gb|OM891864.1| 216750 g75272 i0 91.515 82.8402366863905 165 13 98 1 1 165 4062 4225 Entomoneis cf. alata 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 14000 228 0.991228070175439 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis cf. alata
12312367 12312367 PRJNA846486_P_NODE_17610_length_301_cov_9.404762_g17514_i0 PRJNA846486 17610 301 9.404762 28.30833362 Encyonema minutum 431330 SAR_Eukaryotes SAR_Eukaryotes 505 1.79e-138   NTclustered gi|168145881|emb|AM710515.1| 431330 g17514 i0 100 91.4551495016611 273 0 91 0 29 301 304 32 Encyonema minutum partial 28S rRNA gene, strain AT-137.13 blastn 27528 505 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Encyonema Encyonema minutum
21235315 21235315 PRJNA846486_P_NODE_35817_length_225_cov_1.375000_g35721_i0 PRJNA846486 35817 225 1.375 3.09375 Nitzschia sp. DOCU1 3041873 SAR_Eukaryotes SAR_Eukaryotes 350 6.34e-92   NTclustered gi|2504366779|emb|OX596002.1| 3041873 g35721 i0 97.561 96.8222222222222 205 3 91 2 1 204 28591 28794 Nitzschia sp. DOCU1 genome assembly, organelle: mitochondrion blastn 21785 350 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. DOCU1
21235341 21235341 PRJNA846486_P_NODE_45297_length_205_cov_2.282051_g45201_i0 PRJNA846486 45297 205 2.282051 4.67820455 Gomphonema parvulum 97227 SAR_Eukaryotes SAR_Eukaryotes 313 7.4399999999999995e-81   NTclustered gi|2444483253|gb|OP718170.1| 97227 g45201 i0 94.175 106.331707317073 206 11 100 1 1 205 4730 4525 Gomphonema parvulum mitochondrion, complete genome blastn 21798 313 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
25059449 25059449 PRJNA846486_P_NODE_40960_length_213_cov_2.786585_g40864_i0 PRJNA846486 40960 213 2.786585 5.93542605 Didymosphenia geminata 1115533 SAR_Eukaryotes SAR_Eukaryotes 268 1.7099999999999994e-67   NTclustered gi|1125788738|ref|NC_032171.1| 1115533 g40864 i0 91.795 46.6807511737089 195 12 91 4 1 193 32533 32341 Didymosphenia geminata mitochondrion, complete genome blastn 9943 268 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Didymosphenia Didymosphenia geminata
25059526 25059526 PRJNA846486_P_NODE_82320_length_166_cov_3.316239_g82224_i0 PRJNA846486 82320 166 3.316239 5.50495674 Attheya longicornis 451786 SAR_Eukaryotes SAR_Eukaryotes 102 1.36e-17   NTclustered gi|2046217437|gb|MW729336.1| 451786 g82224 i0 88.235 0.512048192771084 85 10 51 0 2 86 38991 39075 Attheya longicornis mitochondrion, complete genome blastn 85 102 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Attheyaceae Attheya Attheya longicornis

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