RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA541476" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 11 ✖

tax_clade 1

bioproject 1

  • PRJNA541476 · 11 ✖

analysis 1

  • blastn · 11 ✖

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
1784447 1784447 PRJNA541476_P_NODE_3562_length_614_cov_5.295749_g3369_i0 PRJNA541476 3562 614 5.295749 32.51589886 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 368 5.32e-97   NTclustered gi|657012367|gb|KF302531.1| 2850 g3369 i0 86.567 14.4511400651466 335 43 54 2 1 334 52 385 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 8873 368 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
4336070 4336070 PRJNA541476_P_NODE_37924_length_244_cov_0.888889_g37718_i0 PRJNA541476 37924 244 0.888889 2.16888916 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 169 2.09e-37   NTclustered gi|219118894|ref|XM_002180178.1| 556484 g37718 i0 98.936 0.385245901639344 94 1 39 0 151 244 1053 1146 Phaeodactylum tricornutum CCAP 1055/1 predicted protein mRNA blastn 94 169 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
11321572 11321572 PRJNA541476_P_NODE_109_length_2646_cov_4.552662_g85_i0 PRJNA541476 109 2646 4.552662 120.46343652 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 241 5.46e-58   NTclustered gi|2088237800|ref|NC_056903.1| 59812 g85 i0 72.234 17.9134542705971 922 209 34 39 98 1007 6859 5973 Lithodesmium undulatum mitochondrion, complete genome blastn 47399 241 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Lithodesmium Lithodesmium undulatum
11987139 11987139 PRJNA541476_P_NODE_12730_length_328_cov_2.168627_g12524_i0 PRJNA541476 12730 328 2.168627 7.11309656 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 595 1.1399999999999998e-165   NTclustered gi|219127154|ref|XM_002183770.1| 556484 g12524 i0 99.39 1 328 2 100 0 1 328 487 814 Phaeodactylum tricornutum CCAP 1055/1 predicted protein mRNA blastn 328 595 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
14537739 14537739 PRJNA541476_P_NODE_33432_length_247_cov_2.459770_g33226_i0 PRJNA541476 33432 247 2.45977 6.0756319 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 446 8.759999999999998e-121   NTclustered gi|219123192|ref|XM_002181878.1| 556484 g33226 i0 99.19 1.9919028340081 247 2 100 0 1 247 1647 1401 Phaeodactylum tricornutum CCAP 1055/1 predicted protein mRNA blastn 492 446 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
17086225 17086225 PRJNA541476_P_NODE_26114_length_259_cov_1.623656_g25908_i0 PRJNA541476 26114 259 1.623656 4.20526904 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 477 3.2799999999999986e-130   NTclustered gi|219123192|ref|XM_002181878.1| 556484 g25908 i0 100 1.97297297297297 258 0 99 0 2 259 504 247 Phaeodactylum tricornutum CCAP 1055/1 predicted protein mRNA blastn 511 477 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
18360654 18360654 PRJNA541476_P_NODE_38395_length_243_cov_0.917647_g38189_i0 PRJNA541476 38395 243 0.917647 2.22988221 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 167 7.5e-37   NTclustered gi|219127449|ref|XM_002183912.1| 556484 g38189 i0 84.358 0.851851851851852 179 19 72 3 3 178 1189 1017 Phaeodactylum tricornutum CCAP 1055/1 predicted protein mRNA blastn 207 167 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
19635346 19635346 PRJNA541476_P_NODE_42416_length_200_cov_4.385827_g42210_i0 PRJNA541476 42416 200 4.385827 8.771654 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 364 1.96e-96   NTclustered gi|219123192|ref|XM_002181878.1| 556484 g42210 i0 99.5 1 200 1 100 0 1 200 860 661 Phaeodactylum tricornutum CCAP 1055/1 predicted protein mRNA blastn 200 364 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
22185439 22185439 PRJNA541476_P_NODE_23898_length_267_cov_1.190722_g23692_i0 PRJNA541476 23898 267 1.190722 3.17922774 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 488 1.5699999999999998e-133   NTclustered gi|219123192|ref|XM_002181878.1| 556484 g23692 i0 99.625 1.68913857677903 267 1 100 0 1 267 1879 1613 Phaeodactylum tricornutum CCAP 1055/1 predicted protein mRNA blastn 451 488 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
23461001 23461001 PRJNA541476_P_NODE_28239_length_253_cov_0.866667_g28033_i0 PRJNA541476 28239 253 0.866667 2.19266751 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 466 6.9199999999999996e-127   NTclustered gi|219112394|ref|XM_002177913.1| 556484 g28033 i0 100 0.99604743083004 252 0 99 0 2 253 2055 1804 Phaeodactylum tricornutum CCAP 1055/1 chromatin remodeling-related protein mRNA blastn 252 466 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
24735168 24735168 PRJNA541476_P_NODE_4200_length_560_cov_1.492813_g4004_i0 PRJNA541476 4200 560 1.492813 8.3597528 Craticula sp. RGastineau-2025a 3393937 SAR_Eukaryotes SAR_Eukaryotes 117 1.9300000000000003e-21   NTclustered gi|2906190882|gb|PV031684.1| 3393937 g4004 i0 76.316 3.3 228 49 40 4 227 451 63461 63236 Craticula sp. RGastineau-2025a strain SZCZEY2171 mitochondrion, complete genome blastn 1848 117 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Craticula Craticula sp. RGastineau-2025a

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