RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA807347" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA807347 · 4 ✖

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
8459315 8459315 PRJNA807347_P_NODE_3967_length_417_cov_1.500000_g3864_i0 PRJNA807347 3967 417 1.5 6.255 Discostella asterocostata 3014148 SAR_Eukaryotes SAR_Eukaryotes 196 1.75e-45   NTclustered gi|2728412918|gb|OR666650.1| 3014148 g3864 i0 81.857 12.8705035971223 237 39 56 4 1 235 53563 53797 Discostella asterocostata strain SXU-94 chloroplast, complete genome blastn 5367 196 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella asterocostata
13559887 13559887 PRJNA807347_P_NODE_14271_length_247_cov_0.896552_g14168_i0 PRJNA807347 14271 247 0.896552 2.21448344 Coscinodiscus radiatus 33642 SAR_Eukaryotes SAR_Eukaryotes 158 4.6e-34   NTclustered gi|662012523|ref|NC_024081.1| 33642 g14168 i0 79.817 31.004048582996 218 42 88 2 1 217 34364 34580 Coscinodiscus radiatus chloroplast, complete genome blastn 7658 158 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus radiatus
13559935 13559935 PRJNA807347_P_NODE_5491_length_350_cov_1.126354_g5388_i0 PRJNA807347 5491 350 1.126354 3.942239 Climaconeis cf. scalaris 2846828 SAR_Eukaryotes SAR_Eukaryotes 248 3.93e-61   NTclustered gi|2073949216|gb|MZ365055.1| 2846828 g5388 i0 81.879 59.86 298 50 85 4 55 350 117312 117607 Climaconeis cf. scalaris strain SZCZ1889 plastid, complete genome blastn 20951 248 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Berkeleyaceae Climaconeis Climaconeis cf. scalaris
28285703 28285703 PRJNA807347_P_NODE_16666_length_243_cov_0.900000_g16563_i0 PRJNA807347 16666 243 0.9 2.187 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 51.2 3.72e-5   NR KAL3788680.1 29204 g16563 i0 64.3 0.518518518518518 42 11 46.9 1 2 115 454 495 KAL3788680.1 hypothetical protein HJC23_001879 [Cyclotella cryptica] diamond 126 51.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica

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