RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA494251" 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

  • PRJNA494251 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
1750318 1750318 PRJNA494251_P_NODE_34322_length_258_cov_1.432432_g34008_i0 PRJNA494251 34322 258 1.432432 3.69567456 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 267 7.699999999999999e-67   NTclustered gi|657012367|gb|KF302531.1| 2850 g34008 i0 85.49 25.0968992248062 255 37 99 0 4 258 327 73 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 6475 267 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
4302351 4302351 PRJNA494251_P_NODE_4344_length_606_cov_1.765478_g4054_i0 PRJNA494251 4344 606 1.765478 10.69879668 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 477 8.359999999999997e-130   NTclustered gi|223997787|ref|XM_002288531.1| 296543 g4054 i0 81.475 88.4554455445545 583 106 96 2 24 605 1100 1681 Thalassiosira pseudonana CCMP1335 heat shock protein/chaperone (hsp70_4), mRNA blastn 53604 477 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
6853262 6853262 PRJNA494251_P_NODE_926_length_1173_cov_8.245455_g766_i0 PRJNA494251 926 1173 8.245455 96.71918715 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 220 3.1e-52   NTclustered gi|2074156200|gb|MW413905.1| 216802 g766 i0 77.953 36.461210571185 381 65 31 16 519 887 24229 24602 Guinardia delicatula mitochondrion, complete genome blastn 42769 220 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
8128694 8128694 PRJNA494251_S_NODE_787_length_247_cov_0.339080_g772_i0 PRJNA494251 787 247 0.33908 0.8375276 Asterionella formosa 210441 SAR_Eukaryotes SAR_Eukaryotes 108 4.7e-19   NTclustered gi|1111668563|ref|NC_032029.1| 210441 g772 i0 78.75 4.7085020242915 160 34 65 0 20 179 3136 2977 Asterionella formosa strain BGM1 mitochondrion, complete genome blastn 1163 108 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionella Asterionella formosa
10678860 10678860 PRJNA494251_P_NODE_23569_length_297_cov_8.973214_g23255_i0 PRJNA494251 23569 297 8.973214 26.65044558 Attheya septentrionalis 420275 SAR_Eukaryotes SAR_Eukaryotes 364 3.119999999999999e-96   NTclustered gi|2632235279|gb|OR922661.1| 420275 g23255 i0 89.189 99.8922558922559 296 27 99 4 1 296 3248 3538 Attheya septentrionalis strain AGSB0004 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 29668 364 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Attheyaceae Attheya Attheya septentrionalis
14503944 14503944 PRJNA494251_P_NODE_20472_length_314_cov_2.489627_g20158_i0 PRJNA494251 20472 314 2.489627 7.81742878 Minutocellus polymorphus 265543 SAR_Eukaryotes SAR_Eukaryotes 106 2.22e-18   NTclustered gi|2020303798|gb|MW417227.1| 265543 g20158 i0 83.333 29.5382165605096 114 19 36 0 2 115 31611 31498 Minutocellus polymorphus isolate CNS00217 mitochondrion, complete genome blastn 9275 106 1 Eukaryota Sar   Bacillariophyta Mediophyceae Cymatosirales Cymatosiraceae Minutocellus Minutocellus polymorphus
23427890 23427890 PRJNA494251_P_NODE_43799_length_245_cov_1.790698_g43485_i0 PRJNA494251 43799 245 1.790698 4.3872101 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 87.9 6.06e-13   NTclustered gi|2074156200|gb|MW413905.1| 216802 g43485 i0 89.706 2.56734693877551 68 7 28 0 102 169 15298 15231 Guinardia delicatula mitochondrion, complete genome blastn 629 87.9 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);;