RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1087264" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA1087264 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
12947782 12947782 PRJNA1087264_P_NODE_3111_length_374_cov_2.113846_g3030_i0 PRJNA1087264 3111 374 2.113846 7.90578404 Attheya longicornis 451786 SAR_Eukaryotes SAR_Eukaryotes 119 3.46e-22   NTclustered gi|2046217437|gb|MW729336.1| 451786 g3030 i0 81.333 25.1577540106952 150 24 39 4 225 371 38334 38482 Attheya longicornis mitochondrion, complete genome blastn 9409 119 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Attheyaceae Attheya Attheya longicornis
14222725 14222725 PRJNA1087264_P_NODE_1452_length_557_cov_2.000000_g1375_i0 PRJNA1087264 1452 557 2 11.14 Haslea pseudostrearia 197756 SAR_Eukaryotes SAR_Eukaryotes 176 3.12e-39   NTclustered gi|2328347954|ref|NC_067578.1| 197756 g1375 i0 74.944 22.7001795332136 447 80 78 26 1 433 27482 27910 Haslea pseudostrearia strain SCCAP K-1594 mitochondrion, complete genome blastn 12644 176 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea pseudostrearia
14222729 14222729 PRJNA1087264_P_NODE_152_length_1470_cov_3.253343_g130_i0 PRJNA1087264 152 1470 3.253343 47.8241421 Craticula sp. RGastineau-2025a 3393937 SAR_Eukaryotes SAR_Eukaryotes 117 5.27e-21   NTclustered gi|2906190882|gb|PV031684.1| 3393937 g130 i0 76.316 11.4986394557823 228 49 15 4 1146 1370 63236 63461 Craticula sp. RGastineau-2025a strain SZCZEY2171 mitochondrion, complete genome blastn 16903 117 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Craticula Craticula sp. RGastineau-2025a
14222803 14222803 PRJNA1087264_P_NODE_6412_length_251_cov_1.391089_g6330_i0 PRJNA1087264 6412 251 1.391089 3.49163339 Navicula incertata 2014769 SAR_Eukaryotes SAR_Eukaryotes 161 3.62e-35   NTclustered gi|2866543349|gb|PQ722532.1| 2014769 g6330 i0 85.714 66.9003984063745 154 20 61 2 3 155 45573 45421 Navicula incertata mitochondrion, complete genome blastn 16792 161 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula incertata
16770982 16770982 PRJNA1087264_P_NODE_16634_length_165_cov_0.879310_g16552_i0 PRJNA1087264 16634 165 0.87931 1.4508615 Proschkinia sp. SZCZR1824 2588390 SAR_Eukaryotes SAR_Eukaryotes 80.5 6.33e-11   NTclustered gi|1681061561|gb|MH800316.1| 2588390 g16552 i0 76.667 4.16969696969697 150 31 90 4 14 162 4566 4420 Proschkinia sp. SZCZR1824 mitochondrion, complete genome blastn 688 80.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Proschkiniaceae Proschkinia Proschkinia sp. SZCZR1824

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