RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA806354" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

bioproject 1

  • PRJNA806354 · 9 ✖

analysis 1

  • blastn · 9 ✖

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
2081834 2081834 PRJNA806354_P_NODE_39342_length_244_cov_0.900585_g39233_i0 PRJNA806354 39342 244 0.900585 2.1974274 Karenia brevis 156230 SAR_Eukaryotes SAR_Eukaryotes 202 2.07e-47   NTclustered gi|954001123|gb|KT008044.1| 156230 g39233 i0 81.928 21.8114754098361 249 36 99 7 2 244 117 362 Karenia brevis strain CCMP2281 ribosomal protein S5 (rps5) mRNA, complete cds; chloroplast blastn 5322 202 1 Eukaryota Sar     Dinophyceae Gymnodiniales Kareniaceae Karenia Karenia brevis
5909325 5909325 PRJNA806354_P_NODE_1485_length_1075_cov_4.298403_g1415_i0 PRJNA806354 1485 1075 4.298403 46.20783225 Karenia brevis 156230 SAR_Eukaryotes SAR_Eukaryotes 743 0   NTclustered gi|954001087|gb|KR935864.1| 156230 g1415 i0 80.18 73.3209302325581 999 192 93 5 37 1032 1872 2867 Karenia brevis strain CCMP2281 photosystem II subunit A (psbA) mRNA, complete cds; chloroplast blastn 78820 743 1 Eukaryota Sar     Dinophyceae Gymnodiniales Kareniaceae Karenia Karenia brevis
12285532 12285532 PRJNA806354_P_NODE_7730_length_501_cov_10.768692_g7621_i0 PRJNA806354 7730 501 10.768692 53.95114692 Karenia selliformis 262428 SAR_Eukaryotes SAR_Eukaryotes 920 0   NTclustered gi|328685001|gb|HM067007.1| 262428 g7621 i0 99.8 99.9840319361277 501 1 100 0 1 501 1060 560 Karenia selliformis strain CAWD79 18S ribosomal RNA gene, partial sequence blastn 50092 920 1 Eukaryota Sar     Dinophyceae Gymnodiniales Kareniaceae Karenia Karenia selliformis
16525204 16525204 PRJNA806354_P_NODE_5513_length_586_cov_12.159844_g5404_i0 PRJNA806354 5513 586 12.159844 71.25668584 Karenia 156229 SAR_Eukaryotes SAR_Eukaryotes 1079 0   NTclustered gi|2199280008|dbj|LC671820.1| 262428 g5404 i0 99.829 98.117747440273 586 1 100 0 1 586 622 1207 Karenia selliformis MoKr600 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence blastn 57497 1083 0.996306555863343 Eukaryota Sar     Dinophyceae Gymnodiniales Kareniaceae Karenia Karenia selliformis
18657344 18657344 PRJNA806354_P_NODE_19795_length_326_cov_1.992095_g19686_i0 PRJNA806354 19795 326 1.992095 6.4942297 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 582 8.789999999999998e-162   NTclustered gi|2862228860|gb|PQ645494.1| 1923966 g19686 i0 99.377 97.7730061349693 321 2 98 0 4 324 3826 3506 Navicula sp. isolate AGSB0344 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 31874 582 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
19074052 19074052 PRJNA806354_P_NODE_42915_length_209_cov_11.308824_g42806_i0 PRJNA806354 42915 209 11.308824 23.63544216 Gymnodiniales 2953 SAR_Eukaryotes SAR_Eukaryotes 381 2.0599999999999996e-101   NTclustered gi|6465888|gb|AF009216.1|AF009216 58158 g42806 i0 100 98.5693779904306 206 0 99 0 4 209 1644 1439 Gymnodinium cf. mikimotoi small subunit ribosomal RNA gene, complete sequence blastn 20601 381 1 Eukaryota Sar     Dinophyceae Gymnodiniales Gymnodiniaceae Gymnodinium Gymnodinium cf. mikimotoi
19932632 19932632 PRJNA806354_P_NODE_18436_length_336_cov_21.019011_g18327_i0 PRJNA806354 18436 336 21.019011 70.62387696 Prorocentrum micans 2945 SAR_Eukaryotes SAR_Eukaryotes 473 5.709999999999998e-129   NTclustered gi|56117723|gb|AY822609.1| 2945 g18327 i0 92.239 74 335 24 99 2 1 334 2948 3281 Prorocentrum micans large subunit ribosomal RNA gene, complete sequence blastn 24864 473 1 Eukaryota Sar     Dinophyceae Prorocentrales Prorocentraceae Prorocentrum Prorocentrum micans
21208218 21208218 PRJNA806354_P_NODE_18437_length_336_cov_10.771863_g18328_i0 PRJNA806354 18437 336 10.771863 36.19345968 Karenia selliformis 262428 SAR_Eukaryotes SAR_Eukaryotes 616 8.96e-172   NTclustered gi|328685001|gb|HM067007.1| 262428 g18328 i0 100 100.22619047619 333 0 99 0 1 333 333 1 Karenia selliformis strain CAWD79 18S ribosomal RNA gene, partial sequence blastn 33676 616 1 Eukaryota Sar     Dinophyceae Gymnodiniales Kareniaceae Karenia Karenia selliformis
22483039 22483039 PRJNA806354_P_NODE_4678_length_630_cov_13.687612_g4570_i0 PRJNA806354 4678 630 13.687612 86.2319556 Gymnodinium aureolum 107757 SAR_Eukaryotes SAR_Eukaryotes 1142 0   NTclustered gi|110950610|gb|DQ779991.1| 107757 g4570 i0 99.365 99.8825396825397 630 4 100 0 1 630 4009 4638 Gymnodinium aureolum strain GrAr01 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence; and external transcribed spacer, partial sequence blastn 62926 1142 1 Eukaryota Sar     Dinophyceae Gymnodiniales Gymnodiniaceae Gymnodinium Gymnodinium aureolum

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