RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA743294 · 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
7100614 7100614 PRJNA743294_P_NODE_16006_length_402_cov_2.042553_g15550_i0 PRJNA743294 16006 402 2.042553 8.21106306 Chaetoceros messanensis 2749680 SAR_Eukaryotes SAR_Eukaryotes 58.4 8.28e-4   NTclustered gi|1864474647|dbj|LC564874.1| 2749680 g15550 i0 97.143 0.845771144278607 35 0 9 1 368 402 283 316 Chaetoceros messanensis PB-18 gene for large subunit ribosomal RNA, partial sequence blastn 340 58.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros messanensis
7100801 7100801 PRJNA743294_P_NODE_39446_length_270_cov_2.401015_g38990_i0 PRJNA743294 39446 270 2.401015 6.4827405 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 257 4.8900000000000005e-64   NTclustered gi|224010101|ref|XM_002293973.1| 296543 g38990 i0 86.864 87.5185185185185 236 23 87 8 1 235 229 1 Thalassiosira pseudonana CCMP1335 histone H3 partial mRNA blastn 23630 257 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
8375279 8375279 PRJNA743294_P_NODE_2167_length_990_cov_14.660851_g1861_i0 PRJNA743294 2167 990 14.660851 145.1424249 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 425 5.13e-114   NTclustered gi|657012367|gb|KF302531.1| 2850 g1861 i0 87.071 55.5989898989899 379 46 38 3 273 650 17 393 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 55043 425 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
8375283 8375283 PRJNA743294_P_NODE_22027_length_348_cov_1.549091_g21571_i0 PRJNA743294 22027 348 1.549091 5.39083668 Achnanthes kuwaitensis 483531 SAR_Eukaryotes SAR_Eukaryotes 267 1.08e-66   NTclustered gi|225685850|dbj|AB461923.1| 483531 g21571 i0 81.361 2.47988505747126 338 54 96 6 10 343 256 588 Achnanthes kuwaitensis MAT mRNA for methionine S-adenosyl transferase, complete cds blastn 863 267 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Mastogloiales Achnanthaceae Achnanthes Achnanthes kuwaitensis
12201559 12201559 PRJNA743294_P_NODE_49350_length_249_cov_2.397727_g48894_i0 PRJNA743294 49350 249 2.397727 5.97034023 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 300 7.29e-77   NTclustered gi|657012465|gb|KF302574.1| 2850 g48894 i0 88.353 31.8313253012048 249 29 100 0 1 249 50 298 Phaeodactylum tricornutum clone C567 ribosomal protein mRNA, partial cds blastn 7926 300 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
17300122 17300122 PRJNA743294_P_NODE_23114_length_340_cov_3.262172_g22658_i0 PRJNA743294 23114 340 3.262172 11.0913848 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 104 8.74e-18   NTclustered gi|2074156200|gb|MW413905.1| 216802 g22658 i0 98.305 8.1 59 1 17 0 282 340 24614 24556 Guinardia delicatula mitochondrion, complete genome blastn 2754 104 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
23674895 23674895 PRJNA743294_P_NODE_13679_length_432_cov_1.387187_g13223_i0 PRJNA743294 13679 432 1.387187 5.99264784 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 333 1.33e-86   NTclustered gi|657012465|gb|KF302574.1| 2850 g13223 i0 88.172 43.5810185185185 279 33 65 0 1 279 279 1 Phaeodactylum tricornutum clone C567 ribosomal protein mRNA, partial cds blastn 18827 333 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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