RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA849822" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA849822 · 4 ✖

analysis 1

  • blastn · 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
838523 838523 PRJNA849822_P_NODE_17641_length_345_cov_1.529412_g17467_i0 PRJNA849822 17641 345 1.529412 5.2764714 Proschkinia sp. SZCZR1824 2588390 SAR_Eukaryotes SAR_Eukaryotes 80.5 1.5e-10   NTclustered gi|1681061561|gb|MH800316.1| 2588390 g17467 i0 76.433 2.01449275362319 157 31 45 6 64 218 4566 4414 Proschkinia sp. SZCZR1824 mitochondrion, complete genome blastn 695 80.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Proschkiniaceae Proschkinia Proschkinia sp. SZCZR1824
5061516 5061516 PRJNA849822_P_NODE_1824_length_1207_cov_7.646384_g1715_i0 PRJNA849822 1824 1207 7.646384 92.29185488 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 209 6.9100000000000008e-49   NTclustered gi|1169296927|gb|KY364697.1| 29204 g1715 i0 96.094 10.2410936205468 128 5 11 0 779 906 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 12361 209 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
13592323 13592323 PRJNA849822_P_NODE_27551_length_278_cov_1.239024_g27377_i0 PRJNA849822 27551 278 1.239024 3.44448672 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 274 5.02e-69   NTclustered gi|224009485|ref|XM_002293665.1| 296543 g27377 i0 85.496 93.3669064748201 262 38 94 0 17 278 411 150 Thalassiosira pseudonana CCMP1335 histone H3 mRNA blastn 25956 274 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
18689898 18689898 PRJNA849822_P_NODE_21635_length_312_cov_0.811715_g21461_i0 PRJNA849822 21635 312 0.811715 2.5325508 Haslea pseudostrearia 197756 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.029   NTclustered gi|2328348073|ref|NC_067581.1| 197756 g21461 i0 94.286 0.112179487179487 35 0 11 1 135 167 56014 56048 Haslea pseudostrearia strain SCCAP K-1594 chloroplast, complete genome blastn 35 52.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea pseudostrearia

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