contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA690234" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2454147 | 2454147 | PRJNA690234_P_NODE_8822_length_431_cov_2.824022_g8456_i0 | PRJNA690234 | 8822 | 431 | 2.824022 | 12.17153482 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.012 | NTclustered | gi|817746583|ref|XM_012482823.1| | 5857 | g8456 | i0 | 100 | 0.134570765661253 | 29 | 0 | 7 | 0 | 402 | 430 | 1241 | 1213 | Plasmodium fragile uncharacterized protein (AK88_05221), partial mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium fragile | ||
| 3221206 | 3221206 | PRJNA690234_P_NODE_30903_length_243_cov_1.376471_g30536_i0 | PRJNA690234 | 30903 | 243 | 1.376471 | 3.34482453 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.022 | NTclustered | gi|829187266|ref|XM_001033288.2| | 312017 | g30536 | i0 | 100 | 0.11522633744856 | 28 | 0 | 12 | 0 | 129 | 156 | 1611 | 1584 | Tetrahymena thermophila SB210 hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 4498225 | 4498225 | PRJNA690234_P_NODE_24024_length_258_cov_2.627027_g23657_i0 | PRJNA690234 | 24024 | 258 | 2.627027 | 6.77772966 | Mallomonas asmundiae | 64709 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 9.689999999999998e-86 | NTclustered | gi|16326554|gb|AF409122.1| | 64709 | g23657 | i0 | 89.655 | 17.4728682170543 | 261 | 23 | 100 | 4 | 1 | 258 | 3637 | 3896 | Mallomonas asmundae internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence | blastn | 4508 | 329 | 1 | Eukaryota | Sar | Synurophyceae | Synurales | Mallomonadaceae | Mallomonas | Mallomonas asmundiae | |||
| 7048712 | 7048712 | PRJNA690234_P_NODE_21026_length_276_cov_2.729064_g20659_i0 | PRJNA690234 | 21026 | 276 | 2.729064 | 7.53221664 | Philasterides dicentrarchi | 282688 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.46e-29 | NTclustered | gi|49616744|gb|AY643504.1| | 282688 | g20659 | i0 | 84.459 | 1.68840579710145 | 148 | 20 | 53 | 3 | 1 | 146 | 247 | 101 | Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence | blastn | 466 | 143 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philasterides | Philasterides dicentrarchi | ||
| 8831831 | 8831831 | PRJNA690234_P_NODE_33047_length_201_cov_11.632812_g32680_i0 | PRJNA690234 | 33047 | 201 | 11.632812 | 23.38195212 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 372 | 1.18e-98 | NTclustered | gi|2065561668|gb|MZ540265.1| | 44029 | g32680 | i0 | 100 | 99.9950248756219 | 201 | 0 | 100 | 0 | 1 | 201 | 1380 | 1580 | Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence | blastn | 20099 | 372 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium jenningsi | ||
| 9598493 | 9598493 | PRJNA690234_P_NODE_14608_length_332_cov_1.729730_g14241_i0 | PRJNA690234 | 14608 | 332 | 1.72973 | 5.7427036 | Synura synuroidea | 47573 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 2.25e-53 | NTclustered | gi|11466457|ref|NC_002174.1| | 47573 | g14241 | i0 | 79.456 | 68.8524096385542 | 331 | 55 | 98 | 11 | 7 | 332 | 1008 | 686 | Chrysodidymus synuroideus mitochondrion, complete genome | blastn | 22859 | 222 | 1 | Eukaryota | Sar | Synurophyceae | Synurales | Mallomonadaceae | Synura | Synura synuroidea | |||
| 12149634 | 12149634 | PRJNA690234_P_NODE_30210_length_244_cov_1.555556_g29843_i0 | PRJNA690234 | 30210 | 244 | 1.555556 | 3.79555664 | Synura synuroidea | 47573 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 2.15e-17 | NTclustered | gi|11466457|ref|NC_002174.1| | 47573 | g29843 | i0 | 88.372 | 0.352459016393443 | 86 | 9 | 35 | 1 | 1 | 85 | 1090 | 1175 | Chrysodidymus synuroideus mitochondrion, complete genome | blastn | 86 | 102 | 1 | Eukaryota | Sar | Synurophyceae | Synurales | Mallomonadaceae | Synura | Synura synuroidea | |||
| 15972908 | 15972908 | PRJNA690234_P_NODE_2333_length_860_cov_16.968234_g2033_i0 | PRJNA690234 | 2333 | 860 | 16.968234 | 145.9268124 | Ochromonas sp. SAG 933.10 | 984272 | SAR_Eukaryotes | SAR_Eukaryotes | 1356 | 0 | NTclustered | gi|323690578|gb|GU935637.1| | 984272 | g2033 | i0 | 95.145 | 84.2162790697674 | 865 | 33 | 100 | 7 | 1 | 860 | 2001 | 1141 | Ochromonas sp. SAG 933.10 28S ribosomal RNA gene, partial sequence | blastn | 72426 | 1356 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Ochromonas | Ochromonas sp. SAG 933.10 | |||
| 19797318 | 19797318 | PRJNA690234_P_NODE_32716_length_228_cov_2.012903_g32349_i0 | PRJNA690234 | 32716 | 228 | 2.012903 | 4.5894188400000004 | Cryptosporidium felis | 83540 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 9.32e-11 | NTclustered | gi|833025125|gb|KP642067.1| | 83540 | g32349 | i0 | 94.231 | 2.02631578947368 | 52 | 3 | 23 | 0 | 158 | 209 | 1846 | 1795 | Cryptosporidium felis isolate SC142 heat shock protein 70 (HSP70) gene, partial cds | blastn | 462 | 80.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium felis | ||
| 21581069 | 21581069 | PRJNA690234_P_NODE_33057_length_200_cov_7.685039_g32690_i0 | PRJNA690234 | 33057 | 200 | 7.685039 | 15.370078 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 4.22e-98 | NTclustered | gi|2295553597|gb|OP378946.1| | 1117027 | g32690 | i0 | 100 | 100 | 200 | 0 | 100 | 0 | 1 | 200 | 1070 | 871 | Poteriospumella lacustris isolate 1532 large subunit ribosomal RNA gene, partial sequence | blastn | 20000 | 370 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella lacustris | |||
| 22347542 | 22347542 | PRJNA690234_P_NODE_24158_length_258_cov_0.843243_g23791_i0 | PRJNA690234 | 24158 | 258 | 0.843243 | 2.17556694 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 477 | 3.2699999999999985e-130 | NTclustered | gi|325194239|emb|FR825095.1| | 890382 | g23791 | i0 | 100 | 103.81007751938 | 258 | 0 | 100 | 0 | 1 | 258 | 1180 | 923 | Albugo laibachii Nc14, genomic contig CONTIG_1625_NC14_v4_1818_619 | blastn | 26783 | 477 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 22347638 | 22347638 | PRJNA690234_P_NODE_28318_length_247_cov_1.816092_g27951_i0 | PRJNA690234 | 28318 | 247 | 1.816092 | 4.48574724 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 5.659999999999999e-68 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g27951 | i0 | 86.345 | 18.4048582995951 | 249 | 32 | 100 | 2 | 1 | 247 | 3746 | 3994 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 4546 | 270 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 22347733 | 22347733 | PRJNA690234_P_NODE_32158_length_239_cov_5.036145_g31791_i0 | PRJNA690234 | 32158 | 239 | 5.036145 | 12.03638655 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 7.099999999999999e-62 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g31791 | i0 | 90.526 | 71.2133891213389 | 190 | 16 | 79 | 2 | 1 | 189 | 3685 | 3873 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 17020 | 250 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 24130740 | 24130740 | PRJNA690234_P_NODE_15599_length_321_cov_7.629032_g15232_i0 | PRJNA690234 | 15599 | 321 | 7.629032 | 24.48919272 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 588 | 1.8599999999999994e-163 | NTclustered | gi|2065561668|gb|MZ540265.1| | 44029 | g15232 | i0 | 99.688 | 99.595015576324 | 321 | 1 | 100 | 0 | 1 | 321 | 332 | 12 | Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence | blastn | 31970 | 593 | 0.991568296795953 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium jenningsi |
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);;