RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB75230 · 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
6514309 6514309 PRJEB75230_P_NODE_1366_length_1094_cov_4.212537_g1237_i0 PRJEB75230 1366 1094 4.212537 46.08515478 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 521 7.059999999999998e-143   NTclustered gi|657012367|gb|KF302531.1| 2850 g1237 i0 91.169 47.2678244972578 385 32 35 2 272 655 10 393 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 51711 521 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
11614339 11614339 PRJEB75230_P_NODE_10870_length_457_cov_7.875000_g10688_i0 PRJEB75230 10870 457 7.875 35.98875 Lithodesmioides sp. mgcode 4 2914905 SAR_Eukaryotes SAR_Eukaryotes 147 1.98e-30   NTclustered gi|2073953334|gb|MW849271.1| 2914905 g10688 i0 78.298 1.72428884026258 235 45 51 5 94 327 27167 26938 Lithodesmioides sp. mgcode 4 isolate Qingdao in China mitochondrion, complete genome blastn 788 147 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Lithodesmioides Lithodesmioides sp. mgcode 4
12889531 12889531 PRJEB75230_P_NODE_11751_length_446_cov_3.158177_g11569_i0 PRJEB75230 11751 446 3.158177 14.08546942 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 339 2.96e-88   NTclustered gi|2074156200|gb|MW413905.1| 216802 g11569 i0 83.657 77.0560538116592 361 57 81 2 36 395 2057 1698 Guinardia delicatula mitochondrion, complete genome blastn 34367 339 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
12890882 12890882 PRJEB75230_P_NODE_4871_length_623_cov_10.961818_g4690_i0 PRJEB75230 4871 623 10.961818 68.29212614 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 246 2.64e-60   NTclustered gi|657012369|gb|KF302532.1| 2850 g4690 i0 87.097 0.348314606741573 217 28 35 0 104 320 10 226 Phaeodactylum tricornutum clone C80 40S ribosomal protein mRNA, complete cds blastn 217 246 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
12891147 12891147 PRJEB75230_P_NODE_6711_length_545_cov_1.713983_g6529_i0 PRJEB75230 6711 545 1.713983 9.34120735 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 407 9.929999999999998e-109   NTclustered gi|657012465|gb|KF302574.1| 2850 g6529 i0 89.655 59.1779816513762 319 33 59 0 1 319 319 1 Phaeodactylum tricornutum clone C567 ribosomal protein mRNA, partial cds blastn 32252 407 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
12891340 12891340 PRJEB75230_P_NODE_791_length_1357_cov_4.478193_g697_i0 PRJEB75230 791 1357 4.478193 60.76907901 Achnanthes kuwaitensis 483531 SAR_Eukaryotes SAR_Eukaryotes 745 0   NTclustered gi|225685850|dbj|AB461923.1| 483531 g697 i0 78.64 52.1864406779661 1147 227 84 15 177 1317 1147 13 Achnanthes kuwaitensis MAT mRNA for methionine S-adenosyl transferase, complete cds blastn 70817 745 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Mastogloiales Achnanthaceae Achnanthes Achnanthes kuwaitensis

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