contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA1105232" and tax_clade = "Sar"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 212574 | 212574 | PRJNA1105232_S_NODE_3681_length_299_cov_1.628000_g3465_i0 | PRJNA1105232 | 3681 | 299 | 1.628 | 4.86772 | Plasmodium cynomolgi | 5827 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 2.0299999999999993e-43 | NTclustered | gi|457872809|ref|XM_004223276.1| | 1120755 | g3465 | i0 | 79.137 | 2.42809364548495 | 278 | 54 | 92 | 4 | 14 | 289 | 342 | 67 | Plasmodium cynomolgi strain B histone H2A (PCYB_113970) mRNA, complete cds | blastn | 726 | 189 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium cynomolgi | ||
| 1487298 | 1487298 | PRJNA1105232_S_NODE_9242_length_208_cov_2.672956_g9026_i0 | PRJNA1105232 | 9242 | 208 | 2.672956 | 5.55974848 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 2.0900000000000002e-86 | NTclustered | gi|224996436|gb|FJ654268.1| | 188950 | g9026 | i0 | 94.931 | 2.09134615384615 | 217 | 2 | 100 | 1 | 1 | 208 | 122 | 338 | Bodomorpha minima 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 435 | 331 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 2295838 | 2295838 | PRJNA1105232_S_NODE_3042_length_322_cov_2.274725_g2826_i0 | PRJNA1105232 | 3042 | 322 | 2.274725 | 7.3246145 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 6.23e-34 | NTclustered | gi|301119740|ref|XM_002907552.1| | 403677 | g2826 | i0 | 79.149 | 49.6304347826087 | 235 | 43 | 72 | 5 | 1 | 232 | 450 | 219 | Phytophthora infestans T30-4 60S ribosomal protein L23a (PITG_02694), mRNA | blastn | 15981 | 158 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 4039384 | 4039384 | PRJNA1105232_S_NODE_7704_length_223_cov_6.816092_g7488_i0 | PRJNA1105232 | 7704 | 223 | 6.816092 | 15.19988516 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 412 | 7.88e-111 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g7488 | i0 | 100 | 57.0807174887892 | 223 | 0 | 100 | 0 | 1 | 223 | 2911 | 2689 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 12729 | 412 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 6590681 | 6590681 | PRJNA1105232_S_NODE_3566_length_303_cov_9.500000_g3350_i0 | PRJNA1105232 | 3566 | 303 | 9.5 | 28.785 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 514 | 2.99e-141 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g3350 | i0 | 100 | 91.6039603960396 | 278 | 0 | 92 | 0 | 26 | 303 | 39 | 316 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 27756 | 514 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 7865314 | 7865314 | PRJNA1105232_S_NODE_1987_length_377_cov_3.326220_g1771_i0 | PRJNA1105232 | 1987 | 377 | 3.32622 | 12.5398494 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 9.3e-53 | NTclustered | gi|1027955952|ref|XM_016798456.1| | 31271 | g1771 | i0 | 77.6 | 19.790450928382 | 375 | 76 | 98 | 8 | 5 | 375 | 917 | 547 | Plasmodium chabaudi chabaudi rRNA 2'-O-methyltransferase fibrillarin, putative (PCHAS_1035900), partial mRNA | blastn | 7461 | 220 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 7865358 | 7865358 | PRJNA1105232_S_NODE_9247_length_208_cov_2.459119_g9031_i0 | PRJNA1105232 | 9247 | 208 | 2.459119 | 5.11496752 | uncultured dinoflagellate | 187300 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 2.94e-25 | NTclustered | gi|309254621|gb|GU554557.1| | 187300 | g9031 | i0 | 82.313 | 3.62019230769231 | 147 | 26 | 71 | 0 | 4 | 150 | 357 | 211 | uncultured dinoflagellate clone AP_1061048708622 mRNA sequence | blastn | 753 | 128 | 1 | Eukaryota | Sar | Dinophyceae | uncultured dinoflagellate | ||||||
| 9140206 | 9140206 | PRJNA1105232_S_NODE_5848_length_249_cov_2.860000_g5632_i0 | PRJNA1105232 | 5848 | 249 | 2.86 | 7.1214 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 2.7899999999999996e-31 | NTclustered | gi|675169594|ref|XM_008895434.1| | 761204 | g5632 | i0 | 79.245 | 3.71084337349398 | 212 | 44 | 85 | 0 | 35 | 246 | 482 | 271 | Phytophthora parasitica INRA-310 40S ribosomal protein S16 mRNA | blastn | 924 | 148 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 9140208 | 9140208 | PRJNA1105232_S_NODE_6348_length_241_cov_2.369792_g6132_i0 | PRJNA1105232 | 6348 | 241 | 2.369792 | 5.71119872 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 4.4399999999999997e-39 | NTclustered | gi|124804503|ref|XM_001347986.1| | 36329 | g6132 | i0 | 84.659 | 48.6182572614108 | 176 | 25 | 73 | 1 | 37 | 212 | 1551 | 1378 | Plasmodium falciparum 3D7 heat shock protein 70 (PF3D7_1134000), partial mRNA | blastn | 11717 | 174 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 10416014 | 10416014 | PRJNA1105232_S_NODE_169_length_1376_cov_16.330821_g15_i0 | PRJNA1105232 | 169 | 1376 | 16.330821 | 224.71209696 | Loxophyllum shini | 1346494 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 9.87e-73 | NTclustered | gi|375305428|gb|JF975388.1| | 1346494 | g15 | i0 | 79.952 | 22.984011627907 | 419 | 63 | 30 | 17 | 962 | 1376 | 1224 | 823 | Loxophyllum shini isolate PHB2007053101 28S ribosomal RNA gene, partial sequence | blastn | 31626 | 289 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Pleurostomatida | Litonotidae | Loxophyllum | Loxophyllum shini | ||
| 11691288 | 11691288 | PRJNA1105232_S_NODE_3810_length_295_cov_1.463415_g3594_i0 | PRJNA1105232 | 3810 | 295 | 1.463415 | 4.31707425 | Colpodella angusta | 1541798 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 7.19e-43 | NTclustered | gi|972268869|gb|KU159286.1| | 1541798 | g3594 | i0 | 81.938 | 57.6677966101695 | 227 | 36 | 76 | 5 | 71 | 295 | 3696 | 3919 | Colpodella angusta 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 17012 | 187 | 1 | Eukaryota | Sar | Colpodellaceae | Colpodella | Colpodella angusta | |||||
| 11691312 | 11691312 | PRJNA1105232_S_NODE_9130_length_209_cov_2.481250_g8914_i0 | PRJNA1105232 | 9130 | 209 | 2.48125 | 5.1858125 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 4.42e-103 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g8914 | i0 | 100 | 80.8133971291866 | 209 | 0 | 100 | 0 | 1 | 209 | 1676 | 1468 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 16890 | 387 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 14241422 | 14241422 | PRJNA1105232_S_NODE_4832_length_268_cov_49.675799_g4616_i0 | PRJNA1105232 | 4832 | 268 | 49.675799 | 133.13114132 | Phalacroma oxytoxoides | 447216 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.025 | NTclustered | gi|2742502725|gb|PP905714.1| | 447216 | g4616 | i0 | 100 | 0.208955223880597 | 28 | 0 | 10 | 0 | 1 | 28 | 1198 | 1225 | Phalacroma oxytoxoides isolate PhaFC3 small subunit ribosomal RNA gene, partial sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Dinophyceae | Dinophysales | Dinophysaceae | Phalacroma | Phalacroma oxytoxoides | |||
| 15048101 | 15048101 | PRJNA1105232_S_NODE_1552_length_412_cov_5.793388_g1337_i0 | PRJNA1105232 | 1552 | 412 | 5.793388 | 23.86875856 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 761 | 0 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g1337 | i0 | 100 | 100.502427184466 | 412 | 0 | 100 | 0 | 1 | 412 | 1034 | 623 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 41407 | 761 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 16789700 | 16789700 | PRJNA1105232_S_NODE_1154_length_462_cov_10.220339_g940_i0 | PRJNA1105232 | 1154 | 462 | 10.220339 | 47.21796618 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 3.14e-73 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g940 | i0 | 82.222 | 38.5476190476191 | 360 | 40 | 77 | 16 | 106 | 462 | 4039 | 3701 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 17809 | 289 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 24438489 | 24438489 | PRJNA1105232_S_NODE_14460_length_172_cov_4.056911_g14244_i0 | PRJNA1105232 | 14460 | 172 | 4.056911 | 6.97788692 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 1.2899999999999999e-82 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g14244 | i0 | 100 | 1 | 172 | 0 | 100 | 0 | 1 | 172 | 2205 | 2376 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 172 | 318 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima |
Advanced export
JSON shape: default, array, newline-delimited
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);;