RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA1145997" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

  • Sar · 13 ✖

bioproject 1

  • PRJNA1145997 · 13 ✖

analysis 1

  • blastn · 13 ✖

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
1033571 1033571 PRJNA1145997_P_NODE_51261_length_212_cov_11.424460_g48642_i0 PRJNA1145997 51261 212 11.42446 24.2198552 Dinophyceae 2864 SAR_Eukaryotes SAR_Eukaryotes 71.3 5.15e-8   NTclustered gi|387177844|gb|JX001492.1| 400756 g48642 i0 100 7.38207547169811 38 0 18 0 175 212 344 381 Durinskia baltica clone C17903 cytochrome oxidase subunit 3 (cox3) pseudogene, partial sequence; mitochondrial blastn 1565 71.3 1 Eukaryota Sar     Dinophyceae Peridiniales Kryptoperidiniaceae Durinskia Durinskia baltica
2840258 2840258 PRJNA1145997_P_NODE_33883_length_322_cov_4.995984_g31264_i0 PRJNA1145997 33883 322 4.995984 16.08706848 Tribonema sp. 2679974 SAR_Eukaryotes SAR_Eukaryotes 370 7.35e-98   NTclustered gi|2518133535|gb|OQ243223.1| 2679974 g31264 i0 88.673 94.4689440993789 309 27 94 6 21 322 2779 3086 Tribonema sp. strain GXU-A10 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and 28S-18S ribosomal RNA intergenic spacer, complete sequence blastn 30419 370 1 Eukaryota Sar     Xanthophyceae Tribonematales Tribonemataceae Tribonema Tribonema sp.
4116692 4116692 PRJNA1145997_P_NODE_48324_length_243_cov_0.917647_g45705_i0 PRJNA1145997 48324 243 0.917647 2.22988221 Peronospora arvensis 162115 SAR_Eukaryotes SAR_Eukaryotes 438 1.4399999999999996e-118   NTclustered gi|23306508|gb|AY035491.1| 162115 g45705 i0 99.177 99.9259259259259 243 2 100 0 1 243 41 283 Peronospora arvensis isolate MG 15-10 large subunit ribosomal RNA gene, partial sequence blastn 24282 438 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora arvensis
10493109 10493109 PRJNA1145997_P_NODE_33809_length_323_cov_3.704000_g31190_i0 PRJNA1145997 33809 323 3.704 11.96392 Pfiesteria piscicida 71001 SAR_Eukaryotes SAR_Eukaryotes 121 8.1999999999999994e-23   NTclustered gi|255965267|gb|FJ599885.1| 71001 g31190 i0 93.75 0.795665634674923 80 5 25 0 90 169 141 62 Pfiesteria piscicida clone Ppi+Rhod_cDNA14 unknown mRNA; mitochondrial blastn 257 121 1 Eukaryota Sar     Dinophyceae Peridiniales Pfiesteriaceae Pfiesteria Pfiesteria piscicida
13043387 13043387 PRJNA1145997_P_NODE_50791_length_224_cov_6.185430_g48172_i0 PRJNA1145997 50791 224 6.18543 13.8553632 Carchesium polypinum 168244 SAR_Eukaryotes SAR_Eukaryotes 377 2.89e-100   NTclustered gi|237502307|gb|FJ810403.1| 168244 g48172 i0 100 91.1339285714286 204 0 91 0 1 204 820 617 Carchesium polypinum isolate NR28 internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 20414 377 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Carchesium Carchesium polypinum
15592364 15592364 PRJNA1145997_P_NODE_34833_length_311_cov_3.071429_g32214_i0 PRJNA1145997 34833 311 3.071429 9.55214419 Pfiesteria-like sp. HR1SSeptA5 290075 SAR_Eukaryotes SAR_Eukaryotes 523 5.1199999999999984e-144   NTclustered gi|51847969|gb|AY590483.1| 290075 g32214 i0 99.308 92.2797427652733 289 2 93 0 2 290 2753 2465 Pfiesteria-like sp. HR1SSeptA5 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 28699 523 1 Eukaryota Sar     Dinophyceae Peridiniales Pfiesteriaceae   Pfiesteria-like sp. HR1SSeptA5
16335889 16335889 PRJNA1145997_P_NODE_34753_length_312_cov_3.506276_g32134_i0 PRJNA1145997 34753 312 3.506276 10.93958112 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 383 9.11e-102   NTclustered gi|1591473363|gb|MH286884.1| 4787 g32134 i0 90.378 65.2467948717949 291 28 93 0 22 312 18125 18415 Phytophthora infestans mitochondrion, complete genome blastn 20357 383 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
16335995 16335995 PRJNA1145997_P_NODE_50013_length_234_cov_16.745342_g47394_i0 PRJNA1145997 50013 234 16.745342 39.18410028 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.021   NTclustered gi|1673118409|ref|XM_029364605.1| 94643 g47394 i0 100 4.18803418803419 28 0 12 0 15 42 195 168 Besnoitia besnoiti uncharacterized protein (BESB_061910), partial mRNA blastn 980 52.8 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Besnoitia Besnoitia besnoiti
16866558 16866558 PRJNA1145997_P_NODE_32454_length_341_cov_9.473881_g29835_i0 PRJNA1145997 32454 341 9.473881 32.30593421 Toxoplasma gondii 5811 SAR_Eukaryotes SAR_Eukaryotes 58.4 6.93e-4   NTclustered gi|820700576|tpe|LN714500.1| 432359 g29835 i0 100 0.483870967741935 31 0 9 0 302 332 3259770 3259800 TPA_asm: Toxoplasma gondii VEG, chromosome chrX, complete genome blastn 165 58.4 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Sarcocystidae Toxoplasma Toxoplasma gondii
18140919 18140919 PRJNA1145997_P_NODE_22235_length_614_cov_14.909427_g19634_i0 PRJNA1145997 22235 614 14.909427 91.54388178 Bilabrum cf. latius 3115832 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.005   NTclustered gi|2918369598|emb|OZ237764.1| 3115832 g19634 i0 96.97 0.498371335504886 33 1 5 0 16 48 640594 640562 Bilabrum cf. latius genome assembly, chromosome: 30 blastn 306 56.5 1 Eukaryota Sar     Bigyra Bicosoecida   Bilabrum Bilabrum cf. latius
18885143 18885143 PRJNA1145997_P_NODE_51395_length_209_cov_11.022059_g48776_i0 PRJNA1145997 51395 209 11.022059 23.03610331 Poteriospumella 1117026 SAR_Eukaryotes SAR_Eukaryotes 348 2.09e-91   NTclustered gi|685431582|gb|KF697341.1| 1117027 g48776 i0 100 72.6985645933014 188 0 90 0 22 209 93 280 Poteriospumella lacustris strain JBC07 28S ribosomal RNA gene, partial sequence blastn 15194 348 1 Eukaryota Sar     Chrysophyceae Chromulinales Dinobryaceae Poteriospumella Poteriospumella lacustris
21966268 21966268 PRJNA1145997_P_NODE_32518_length_340_cov_14.509363_g29899_i0 PRJNA1145997 32518 340 14.509363 49.3318342 Ceratium furcoides 1186198 SAR_Eukaryotes SAR_Eukaryotes 392 1.6699999999999995e-104   NTclustered gi|387768997|gb|JQ639748.1| 1186198 g29899 i0 91.349 93.9058823529412 289 21 84 3 52 338 8 294 Ceratium furcoides voucher HBI:SC201002a large subunit ribosomal RNA gene, partial sequence blastn 31928 392 1 Eukaryota Sar     Dinophyceae Gonyaulacales Ceratiaceae Ceratium Ceratium furcoides
24515294 24515294 PRJNA1145997_P_NODE_32720_length_337_cov_5.443182_g30101_i0 PRJNA1145997 32720 337 5.443182 18.34352334 uncultured dinoflagellate 187300 SAR_Eukaryotes SAR_Eukaryotes 211 4.96e-50   NTclustered gi|309255479|gb|GU555415.1| 187300 g30101 i0 80.615 0.964391691394659 325 19 94 9 17 334 1250 1537 uncultured dinoflagellate clone ML2-17 mRNA sequence blastn 325 211 1 Eukaryota Sar     Dinophyceae       uncultured dinoflagellate

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