RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA293022" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA293022 · 7 ✖

analysis 1

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
2334978 2334978 PRJNA293022_P_NODE_58022_length_182_cov_5.624060_g57285_i0 PRJNA293022 58022 182 5.62406 10.2357892 Rhopalodiales 245176 SAR_Eukaryotes SAR_Eukaryotes 315 1.79e-81   NTclustered gi|2325195844|gb|OM494341.1| 186043 g57285 i0 98.333 196.489010989011 180 2 99 1 3 182 89061 89239 Entomoneis sp. isolate C2 plastid, complete genome blastn 35761 315 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.
7437667 7437667 PRJNA293022_P_NODE_61866_length_176_cov_3.094488_g61129_i0 PRJNA293022 61866 176 3.094488 5.44629888 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 316 4.7699999999999983e-82   NTclustered gi|2194766164|gb|OK505009.1| 2856 g61129 i0 99.425 196.181818181818 174 1 99 0 3 176 20225 20398 Cylindrotheca closterium chloroplast, complete genome blastn 34528 316 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
8026521 8026521 PRJNA293022_P_NODE_22567_length_299_cov_1.580000_g21830_i0 PRJNA293022 22567 299 1.58 4.7242 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 403 6.66e-108   NTclustered gi|146762526|gb|EF553458.1| 2850 g21830 i0 91.246 96.866220735786 297 25 99 1 1 297 4237 3942 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 28963 403 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
8026600 8026600 PRJNA293022_P_NODE_3927_length_697_cov_7.030864_g3318_i0 PRJNA293022 3927 697 7.030864 49.00512208 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 185 6.579999999999998e-42   NTclustered gi|2074156200|gb|MW413905.1| 216802 g3318 i0 75 50.0717360114778 444 89 62 17 215 648 24226 24657 Guinardia delicatula mitochondrion, complete genome blastn 34900 185 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
11851865 11851865 PRJNA293022_P_NODE_23730_length_290_cov_4.178423_g22993_i0 PRJNA293022 23730 290 4.1784230000000004 12.1174267 Cocconeiopsis kantsiensis 3082010 SAR_Eukaryotes SAR_Eukaryotes 110 1.5700000000000001e-19   NTclustered gi|2692958369|ref|NC_086887.1| 3082010 g22993 i0 85.047 1.51379310344828 107 16 37 0 16 122 18668 18774 Cocconeiopsis kantsiensis isolate Huiquan Bay in China mitochondrion, complete genome blastn 439 110 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cocconeidales Cocconeidaceae Cocconeiopsis Cocconeiopsis kantsiensis
17637430 17637430 PRJNA293022_P_NODE_9254_length_470_cov_4.498812_g8523_i0 PRJNA293022 9254 470 4.498812 21.1444164 Schizostauron 1880599 SAR_Eukaryotes SAR_Eukaryotes 821 0   NTclustered gi|2633519340|gb|OR805654.1| 2126271 g8523 i0 98.291 197.485106382979 468 8 99 0 1 468 122061 121594 Naviculales sp. strain SZCZO2114 plastid, complete genome blastn 92818 821 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
22736637 22736637 PRJNA293022_P_NODE_9338_length_468_cov_4.739857_g8607_i0 PRJNA293022 9338 468 4.739857 22.18253076 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 839 0   NTclustered gi|2194766164|gb|OK505009.1| 2856 g8607 i0 99.142 197 466 4 99 0 3 468 19270 19735 Cylindrotheca closterium chloroplast, complete genome blastn 92196 839 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium

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