RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA917598 · 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
8549994 8549994 PRJNA917598_P_NODE_84647_length_248_cov_0.880000_g83703_i0 PRJNA917598 84647 248 0.88 2.1824 Nitzschia sp. IriIs04 1444690 SAR_Eukaryotes SAR_Eukaryotes 206 1.6299999999999998e-48   NTclustered gi|944186118|dbj|LC052646.1| 1444690 g83703 i0 84.878 4.85483870967742 205 29 82 2 1 204 1229 1026 Nitzschia sp. IriIs04 hCdc48-1 mRNA for host cell division cycle protein, complete cds blastn 1204 206 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. IriIs04
12375509 12375509 PRJNA917598_P_NODE_55990_length_304_cov_1.333333_g55046_i0 PRJNA917598 55990 304 1.333333 4.05333232 Coscinodiscus granii 265552 SAR_Eukaryotes SAR_Eukaryotes 134 9.83e-27   NTclustered gi|2192941198|ref|NC_060315.1| 265552 g55046 i0 80.105 14.1513157894737 191 28 61 8 118 303 17744 17929 Coscinodiscus granii mitochondrion, complete sequence blastn 4302 134 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus granii
13650908 13650908 PRJNA917598_P_NODE_94271_length_242_cov_0.911243_g93327_i0 PRJNA917598 94271 242 0.911243 2.20520806 Minidiscus trioculatus 265540 SAR_Eukaryotes SAR_Eukaryotes 448 2.3799999999999995e-121   NTclustered gi|817090737|gb|KM009428.1| 265540 g93327 i0 100 130.99173553719 242 0 100 0 1 242 313 72 Minidiscus trioculatus isolate CCMP495 PSII protein D1 (psbA) gene, partial cds; chloroplast blastn 31700 448 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Minidiscus Minidiscus trioculatus
14923978 14923978 PRJNA917598_P_NODE_43652_length_347_cov_5.029197_g42708_i0 PRJNA917598 43652 347 5.029197 17.45131359 Eunotia naegelii 1458866 SAR_Eukaryotes SAR_Eukaryotes 121 8.879999999999999e-23   NTclustered gi|1418586621|ref|NC_037987.1| 1458866 g42708 i0 78.191 3.78386167146974 188 41 54 0 145 332 5914 5727 Eunotia naegelii strain UTEX FD354 mitochondrion, complete genome blastn 1313 121 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Eunotiales Eunotiaceae Eunotia Eunotia naegelii
16199569 16199569 PRJNA917598_P_NODE_67673_length_277_cov_1.122549_g66729_i0 PRJNA917598 67673 277 1.122549 3.10946073 Attheya longicornis 451786 SAR_Eukaryotes SAR_Eukaryotes 119 2.48e-22   NTclustered gi|2046217437|gb|MW729336.1| 451786 g66729 i0 81.333 33.956678700361 150 24 53 4 3 149 38482 38334 Attheya longicornis mitochondrion, complete genome blastn 9406 119 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Attheyaceae Attheya Attheya longicornis
17473523 17473523 PRJNA917598_P_NODE_14974_length_608_cov_2.542056_g14040_i0 PRJNA917598 14974 608 2.542056 15.45570048 Proschkinia sp. SZCZR1824 2588390 SAR_Eukaryotes SAR_Eukaryotes 80.5 2.76e-10   NTclustered gi|1681061561|gb|MH800316.1| 2588390 g14040 i0 76.433 1.14309210526316 157 31 25 6 6 160 4414 4566 Proschkinia sp. SZCZR1824 mitochondrion, complete genome blastn 695 80.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Proschkiniaceae Proschkinia Proschkinia sp. SZCZR1824
18748264 18748264 PRJNA917598_P_NODE_6715_length_934_cov_1.562137_g5945_i0 PRJNA917598 6715 934 1.562137 14.59035958 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 113 4.27e-20   NTclustered gi|2074156200|gb|MW413905.1| 216802 g5945 i0 78.075 2.42826552462527 187 35 20 6 717 900 15113 15296 Guinardia delicatula mitochondrion, complete genome blastn 2268 113 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
19102864 19102864 PRJNA917598_P_NODE_47155_length_334_cov_1.467433_g46211_i0 PRJNA917598 47155 334 1.467433 4.90122622 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 130 1.41e-25   NTclustered gi|2739942907|dbj|LC814767.1| 2843 g46211 i0 89.524 23.2125748502994 105 8 31 3 96 198 7689 7586 Skeletonema costatum SCHP35 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2 and 28S rRNA, partial and complete sequence blastn 7753 130 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum
21299289 21299289 PRJNA917598_P_NODE_96277_length_241_cov_0.863095_g95333_i0 PRJNA917598 96277 241 0.863095 2.08005895 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 407 4.0199999999999995e-109   NTclustered gi|2633519340|gb|OR805654.1| 2126271 g95333 i0 97.095 198.609958506224 241 7 100 0 1 241 122028 121788 Naviculales sp. strain SZCZO2114 plastid, complete genome blastn 47865 407 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
21653387 21653387 PRJNA917598_P_NODE_29837_length_421_cov_1.959770_g28893_i0 PRJNA917598 29837 421 1.95977 8.2506317 root 1 Root_unresolved Root_unresolved 99 5.13e-16   NTclustered gi|2846854574|gb|PQ459335.1| 37318 g28893 i0 78.481 32.9311163895487 158 28 37 6 17 171 34236 34390 Pseudo-nitzschia pungens isolate CNS00055 mitochondrion, complete genome blastn 13864 99 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia pungens
25478290 25478290 PRJNA917598_P_NODE_83620_length_249_cov_0.875000_g82676_i0 PRJNA917598 83620 249 0.875 2.17875 Actinocyclus 49230 SAR_Eukaryotes SAR_Eukaryotes 411 3.2299999999999996e-110   NTclustered gi|511649001|gb|KC309668.1| 1335100 g82676 i0 96.386 99.9638554216867 249 9 100 0 1 249 289 41 Actinocyclus sp. 1 MPA-2013 isolate ECT3899tinydrum photosystem II CP43 protein (psbC) gene, partial cds; plastid blastn 24891 411 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Hemidiscaceae Actinocyclus Actinocyclus sp. 1 MPA-2013

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