RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA857143" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA857143 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
2119719 2119719 PRJNA857143_S_NODE_66742_length_360_cov_3.620209_g65649_i0 PRJNA857143 66742 360 3.620209 13.0327524 Coscinodiscus granii 265552 SAR_Eukaryotes SAR_Eukaryotes 91.6 7.23e-14   NTclustered gi|2192941198|ref|NC_060315.1| 265552 g65649 i0 84.375 29.0444444444444 96 12 26 3 1 95 26343 26436 Coscinodiscus granii mitochondrion, complete sequence blastn 10456 91.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus granii
8497202 8497202 PRJNA857143_S_NODE_67007_length_360_cov_1.613240_g65914_i0 PRJNA857143 67007 360 1.61324 5.807664 Pseudo-nitzschia pungens 37318 SAR_Eukaryotes SAR_Eukaryotes 143 1.97e-29   NTclustered gi|2846854574|gb|PQ459335.1| 37318 g65914 i0 89.474 56.225 114 11 32 1 3 116 35813 35925 Pseudo-nitzschia pungens isolate CNS00055 mitochondrion, complete genome blastn 20241 143 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia pungens
16145921 16145921 PRJNA857143_S_NODE_134993_length_279_cov_1.135922_g133900_i0 PRJNA857143 134993 279 1.135922 3.16922238 Skeletonema japonicum 267983 SAR_Eukaryotes SAR_Eukaryotes 110 1.5e-19   NTclustered gi|2739942918|dbj|LC814778.1| 267983 g133900 i0 86.869 4.75627240143369 99 11 35 2 125 222 19192 19095 Skeletonema japonicum SJ_T01 mitochondrial DNA, complete genome blastn 1327 110 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema japonicum
18695709 18695709 PRJNA857143_S_NODE_74675_length_347_cov_1.138686_g73582_i0 PRJNA857143 74675 347 1.138686 3.95124042 Navicula incertata 2014769 SAR_Eukaryotes SAR_Eukaryotes 195 5.1599999999999995e-45   NTclustered gi|2866543349|gb|PQ722532.1| 2014769 g73582 i0 85.87 60.0086455331412 184 24 53 2 65 247 45603 45421 Navicula incertata mitochondrion, complete genome blastn 20823 195 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula incertata
22520464 22520464 PRJNA857143_S_NODE_192818_length_243_cov_0.917647_g191725_i0 PRJNA857143 192818 243 0.917647 2.22988221 Pseudo-nitzschia americana 44446 SAR_Eukaryotes SAR_Eukaryotes 167 7.5e-37   NTclustered gi|2852238151|gb|PQ498356.1| 44446 g191725 i0 82.383 17.8024691358025 193 32 79 2 29 220 20867 21058 Pseudo-nitzschia americana isolate CNS00138 mitochondrion, complete genome blastn 4326 167 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia americana
22520725 22520725 PRJNA857143_S_NODE_37998_length_431_cov_4.430168_g36906_i0 PRJNA857143 37998 431 4.430168 19.09402408 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 122 3.129999999999999e-23   NTclustered gi|2074156200|gb|MW413905.1| 216802 g36906 i0 77.273 19.5336426914153 220 42 50 5 54 268 24392 24608 Guinardia delicatula mitochondrion, complete genome blastn 8419 122 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula

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