RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1046144 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
2723046 2723046 PRJNA1046144_P_NODE_5343_length_680_cov_4.472995_g5064_i0 PRJNA1046144 5343 680 4.472995 30.416366 Poterioochromonas malhamensis 88167 SAR_Eukaryotes SAR_Eukaryotes 1256 0   NTclustered gi|323690576|gb|GU935635.1| 88167 g5064 i0 100 84.3632352941176 680 0 100 0 1 680 1340 2019 Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence blastn 57367 1256 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
5274892 5274892 PRJNA1046144_P_NODE_28445_length_313_cov_3.360656_g28150_i0 PRJNA1046144 28445 313 3.360656 10.51885328 Poteriospumella lacustris 1117027 SAR_Eukaryotes SAR_Eukaryotes 568 2.3499999999999998e-157   NTclustered gi|2295553597|gb|OP378946.1| 1117027 g28150 i0 99.361 99.741214057508 313 2 100 0 1 313 1661 1349 Poteriospumella lacustris isolate 1532 large subunit ribosomal RNA gene, partial sequence blastn 31219 568 1 Eukaryota Sar     Chrysophyceae Chromulinales Dinobryaceae Poteriospumella Poteriospumella lacustris
9100147 9100147 PRJNA1046144_P_NODE_5288_length_684_cov_3.227642_g5009_i0 PRJNA1046144 5288 684 3.227642 22.07707128 Karenia brevis 156230 SAR_Eukaryotes SAR_Eukaryotes 1236 0   NTclustered gi|954001107|gb|KR935875.1| 156230 g5009 i0 100 103.285087719298 669 0 98 0 16 684 1023 355 Karenia brevis strain CCM2281 ribosomal protein S23 (rps23) mRNA, complete cds; chloroplast blastn 70647 1236 1 Eukaryota Sar     Dinophyceae Gymnodiniales Kareniaceae Karenia Karenia brevis
21849065 21849065 PRJNA1046144_P_NODE_32478_length_296_cov_3.568282_g32183_i0 PRJNA1046144 32478 296 3.568282 10.56211472 Poterioochromonas malhamensis 88167 SAR_Eukaryotes SAR_Eukaryotes 534 2.24e-147   NTclustered gi|323690576|gb|GU935635.1| 88167 g32183 i0 99.658 94.6891891891892 292 1 99 0 1 292 292 1 Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence blastn 28028 534 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
23961823 23961823 PRJNA1046144_P_NODE_65639_length_228_cov_2.754717_g65344_i0 PRJNA1046144 65639 228 2.754717 6.28075476 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 422 1.34e-113   NTclustered gi|323690576|gb|GU935635.1| 88167 g65344 i0 100 99.5043859649123 228 0 100 0 1 228 894 1121 Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence blastn 22687 422 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
23961883 23961883 PRJNA1046144_P_NODE_72199_length_184_cov_4.304348_g71904_i0 PRJNA1046144 72199 184 4.304348 7.92000032 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 340 2.99e-89   NTclustered gi|1409222725|gb|MH536659.1| 88167 g71904 i0 100 100 184 0 100 0 1 184 1443 1626 Poterioochromonas malhamensis strain SAG933-1d small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence blastn 18400 340 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
25235627 25235627 PRJNA1046144_P_NODE_58320_length_234_cov_0.872727_g58025_i0 PRJNA1046144 58320 234 0.872727 2.04218118 Plasmodium 5820 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.006   NTclustered gi|2785768418|ref|XM_067219295.1| 5824 g58025 i0 100 0.508547008547009 29 0 12 0 145 173 496 468 Plasmodium brasilianum uncharacterized protein (MKS88_000239), partial mRNA blastn 119 54.7 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium brasilianum

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