RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA841653" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA841653 · 10 ✖

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
2105644 2105644 PRJNA841653_P_NODE_19842_length_366_cov_2.883959_g19170_i0 PRJNA841653 19842 366 2.883959 10.55528994 Sundstroemia setigera 3005 SAR_Eukaryotes SAR_Eukaryotes 196 1.52e-45   NTclustered gi|2172620428|ref|NC_059919.1| 3005 g19170 i0 86.339 51.8196721311475 183 22 49 3 135 315 24963 24782 Rhizosolenia setigera isolate CNS00456 mitochondrion, complete genome blastn 18966 196 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Sundstroemia Sundstroemia setigera
4658790 4658790 PRJNA841653_P_NODE_29464_length_300_cov_1.599119_g28790_i0 PRJNA841653 29464 300 1.599119 4.797357 Stauroneis acuta 1003109 SAR_Eukaryotes SAR_Eukaryotes 472 1.81e-128   NTclustered gi|329343408|gb|HQ912579.1| 1003109 g28790 i0 95.593 98.27 295 12 98 1 1 295 899 606 Stauroneis acuta strain UTEX FD51 18S small subunit ribosomal RNA gene, partial sequence blastn 29481 472 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Stauroneis Stauroneis acuta
7208733 7208733 PRJNA841653_P_NODE_36266_length_273_cov_1.510000_g35592_i0 PRJNA841653 36266 273 1.51 4.1223 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 353 6.14e-93   NTclustered gi|2620230842|gb|OR797293.1| 1923966 g35592 i0 90.074 49.6630036630037 272 27 99 0 2 273 3967 4238 Navicula sp. strain SZCZEY2262 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 13558 353 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
8483433 8483433 PRJNA841653_P_NODE_4127_length_851_cov_3.609254_g3554_i0 PRJNA841653 4127 851 3.609254 30.71475154 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 182 1.0499999999999999e-40   NTclustered gi|2074156200|gb|MW413905.1| 216802 g3554 i0 73.93 109.512338425382 514 106 59 24 180 678 24657 24157 Guinardia delicatula mitochondrion, complete genome blastn 93195 182 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
13583678 13583678 PRJNA841653_P_NODE_12311_length_472_cov_2.486216_g11640_i0 PRJNA841653 12311 472 2.486216 11.73493952 Navicula incertata 2014769 SAR_Eukaryotes SAR_Eukaryotes 835 0   NTclustered gi|2866543221|gb|PQ722531.1| 2014769 g11640 i0 98.929 197.21186440678 467 5 99 0 6 472 72520 72986 Navicula incertata chloroplast, complete genome blastn 93084 835 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula incertata
18681877 18681877 PRJNA841653_P_NODE_39495_length_262_cov_2.476190_g38821_i0 PRJNA841653 39495 262 2.47619 6.4876178 Poulinea lepidochelicola 2925282 SAR_Eukaryotes SAR_Eukaryotes 440 4.369999999999998e-119   NTclustered gi|2283858605|gb|OP184797.1| 2925282 g38821 i0 98.4 95.6946564885496 250 4 95 0 1 250 366 117 Poulinea lepidochelicola strain PMTB0077 small subunit ribosomal RNA gene, partial sequence blastn 25072 440 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Rhoicospheniaceae Poulinea Poulinea lepidochelicola
18681964 18681964 PRJNA841653_P_NODE_43015_length_251_cov_4.455056_g42341_i0 PRJNA841653 43015 251 4.455056 11.18219056 Astrosyne radiata 1158023 SAR_Eukaryotes SAR_Eukaryotes 110 1.33e-19   NTclustered gi|1418588773|ref|NC_038008.1| 1158023 g42341 i0 76.847 77.6733067729084 203 41 80 6 52 251 64712 64911 Astrosyne radiata chloroplast, complete genome blastn 19496 110 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Cyclophorales Cyclophoraceae Astrosyne Astrosyne radiata
22507842 22507842 PRJNA841653_P_NODE_64438_length_203_cov_364.353846_g63764_i0 PRJNA841653 64438 203 364.353846 739.63830738 Guinardia striata 1514137 SAR_Eukaryotes SAR_Eukaryotes 150 6.1e-32   NTclustered gi|2202538957|gb|OM891863.1| 1514137 g63764 i0 81.771 94.5369458128079 192 24 95 7 10 201 5546 5726 Guinardia striata small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 19191 150 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia striata
23782835 23782835 PRJNA841653_P_NODE_36419_length_272_cov_4.000000_g35745_i0 PRJNA841653 36419 272 4 10.88 Stauroneis hamiltonii 3158580 SAR_Eukaryotes SAR_Eukaryotes 359 1.31e-94   NTclustered gi|2739195896|gb|PP864727.1| 3158580 g35745 i0 90.809 72.9926470588235 272 20 98 1 1 267 297 26 Stauroneis hamiltonii isolate c109 large subunit ribosomal RNA gene, partial sequence blastn 19854 359 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Stauroneis Stauroneis hamiltonii
30094594 30094594 PRJNA841653_P_NODE_32152_length_288_cov_1.172093_g31478_i0 PRJNA841653 32152 288 1.172093 3.37562784 root 1 Root_unresolved Root_unresolved 62 1.05e-8   NR GFH59123.1 426638 g31478 i0 39.5 2.59375 76 46 79.2 0 9 236 562 637 GFH59123.1 chaperone, heat shock protein 70 [Chaetoceros tenuissimus] diamond 747 62.4 0.993589743589744 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus

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