contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA902848" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 882084 | 882084 | PRJNA902848_P_NODE_20541_length_233_cov_2.237500_g20491_i0 | PRJNA902848 | 20541 | 233 | 2.2375 | 5.213375 | Synura synuroidea | 47573 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 5.48e-43 | NTclustered | gi|11466457|ref|NC_002174.1| | 47573 | g20491 | i0 | 83.495 | 1.27038626609442 | 206 | 29 | 87 | 4 | 32 | 233 | 1175 | 971 | Chrysodidymus synuroideus mitochondrion, complete genome | blastn | 296 | 187 | 1 | Eukaryota | Sar | Synurophyceae | Synurales | Mallomonadaceae | Synura | Synura synuroidea | |||
| 1247019 | 1247019 | PRJNA902848_P_NODE_20641_length_211_cov_11.427536_g20591_i0 | PRJNA902848 | 20641 | 211 | 11.427536 | 24.11210096 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 390 | 3.459999999999999e-104 | NTclustered | gi|2065561668|gb|MZ540265.1| | 44029 | g20591 | i0 | 100 | 100.004739336493 | 211 | 0 | 100 | 0 | 1 | 211 | 1367 | 1577 | Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence | blastn | 21101 | 390 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium jenningsi | ||
| 5075149 | 5075149 | PRJNA902848_P_NODE_20664_length_200_cov_13.535433_g20614_i0 | PRJNA902848 | 20664 | 200 | 13.535433 | 27.070866 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 4.22e-98 | NTclustered | gi|1802599794|gb|MT001203.1| | 41631 | g20614 | i0 | 100 | 100.075 | 200 | 0 | 100 | 0 | 1 | 200 | 1563 | 1364 | Colpoda sp. strain HFCC848 small subunit ribosomal RNA gene, partial sequence | blastn | 20015 | 370 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 5985327 | 5985327 | PRJNA902848_P_NODE_19345_length_243_cov_0.917647_g19295_i0 | PRJNA902848 | 19345 | 243 | 0.917647 | 2.22988221 | Symbiodinium kawagutii | 104179 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 3.09e-120 | NTclustered | gi|512786524|gb|KC943146.1| | 104179 | g19295 | i0 | 99.588 | 3.51440329218107 | 243 | 1 | 100 | 0 | 1 | 243 | 58 | 300 | Symbiodinium kawagutii strain CCMP2468 clone SymkaFL1061064220497(5'-), partial sequence | blastn | 854 | 444 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium kawagutii | |||
| 5985500 | 5985500 | PRJNA902848_P_NODE_7925_length_312_cov_9.635983_g7875_i0 | PRJNA902848 | 7925 | 312 | 9.635983 | 30.06426696 | Frontonia canadensis | 1590099 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 7.09e-98 | NTclustered | gi|742270343|gb|KJ475286.1| | 1590099 | g7875 | i0 | 88.141 | 100.173076923077 | 312 | 35 | 100 | 2 | 1 | 312 | 883 | 1192 | Frontonia canadensis isolate S21L large subunit ribosomal RNA gene, partial sequence | blastn | 31254 | 370 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Frontoniidae | Frontonia | Frontonia canadensis | ||
| 5985518 | 5985518 | PRJNA902848_P_NODE_8725_length_301_cov_4.350877_g8675_i0 | PRJNA902848 | 8725 | 301 | 4.350877 | 13.09613977 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 3.9599999999999996e-120 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g8675 | i0 | 93.355 | 90.6644518272425 | 301 | 19 | 100 | 1 | 1 | 301 | 1633 | 1334 | Vorticella sp. 4 JG-2011 clone 2 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 | 27290 | 444 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 7260323 | 7260323 | PRJNA902848_P_NODE_9706_length_288_cov_2.827907_g9656_i0 | PRJNA902848 | 9706 | 288 | 2.827907 | 8.14437216 | Conchophthirus curtus | 2675438 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 1.95e-43 | NTclustered | gi|2518630383|gb|OR129888.1| | 2675438 | g9656 | i0 | 80.153 | 12.2013888888889 | 262 | 45 | 90 | 7 | 1 | 259 | 1159 | 902 | Conchophthirus curtus isolate HO 30 UC internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 3514 | 189 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Conchophthiridae | Conchophthirus | Conchophthirus curtus | ||
| 9809784 | 9809784 | PRJNA902848_P_NODE_13208_length_253_cov_0.866667_g13158_i0 | PRJNA902848 | 13208 | 253 | 0.866667 | 2.19266751 | Babesia caballi | 5871 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|2794946118|ref|XM_067860381.1| | 5871 | g13158 | i0 | 100 | 0.229249011857708 | 29 | 0 | 11 | 0 | 102 | 130 | 4213 | 4185 | Babesia caballi heat shock protein DNAJ pfj4, putative (BcabD6B2_38480), partial mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 10175664 | 10175664 | PRJNA902848_P_NODE_5208_length_365_cov_12.301370_g5158_i0 | PRJNA902848 | 5208 | 365 | 12.30137 | 44.9000005 | Colpoda | 5979 | SAR_Eukaryotes | SAR_Eukaryotes | 675 | 0 | NTclustered | gi|82470179|gb|DQ244022.1| | 175274 | g5158 | i0 | 100 | 95.345205479452 | 365 | 0 | 100 | 0 | 1 | 365 | 10 | 374 | Uncultured alveolate clone PAB6AU2004 18S ribosomal RNA gene, partial sequence | blastn | 34801 | 675 | 1 | Eukaryota | Sar | uncultured alveolate | |||||||
| 11085760 | 11085760 | PRJNA902848_P_NODE_5249_length_365_cov_0.955479_g5199_i0 | PRJNA902848 | 5249 | 365 | 0.955479 | 3.48749835 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 523 | 6.109999999999999e-144 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g5199 | i0 | 92.582 | 98.1917808219178 | 364 | 27 | 99 | 0 | 1 | 364 | 590 | 227 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 35840 | 523 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 11085805 | 11085805 | PRJNA902848_P_NODE_6949_length_330_cov_0.906615_g6899_i0 | PRJNA902848 | 6949 | 330 | 0.906615 | 2.9918295 | Synura synuroidea | 47573 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 2.22e-58 | NTclustered | gi|11466457|ref|NC_002174.1| | 47573 | g6899 | i0 | 81.757 | 61.7212121212121 | 296 | 45 | 88 | 9 | 1 | 292 | 575 | 865 | Chrysodidymus synuroideus mitochondrion, complete genome | blastn | 20368 | 239 | 1 | Eukaryota | Sar | Synurophyceae | Synurales | Mallomonadaceae | Synura | Synura synuroidea | |||
| 14001094 | 14001094 | PRJNA902848_P_NODE_8251_length_308_cov_1.136170_g8201_i0 | PRJNA902848 | 8251 | 308 | 1.13617 | 3.4994036 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 564 | 2.99e-156 | NTclustered | gi|363412153|gb|JN120227.1| | 60850 | g8201 | i0 | 99.675 | 99.0064935064935 | 308 | 1 | 100 | 0 | 1 | 308 | 512 | 819 | Vorticella convallaria isolate 96Vorsp16 18S ribosomal RNA gene, partial sequence | blastn | 30494 | 564 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella convallaria | ||
| 16184874 | 16184874 | PRJNA902848_P_NODE_2993_length_449_cov_8.085106_g2943_i0 | PRJNA902848 | 2993 | 449 | 8.085106 | 36.30212594 | Cardiostomatella vermiformis | 311390 | SAR_Eukaryotes | SAR_Eukaryotes | 507 | 7.72e-139 | NTclustered | gi|404425895|gb|JX310024.1| | 311390 | g2943 | i0 | 89.021 | 93.5523385300668 | 419 | 33 | 92 | 11 | 1 | 413 | 2020 | 2431 | Cardiostomatella vermiformis voucher FXP2007101002 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 42005 | 507 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Loxocephalidae | Cardiostomatella | Cardiostomatella vermiformis | ||
| 17824532 | 17824532 | PRJNA902848_P_NODE_20654_length_205_cov_15.371212_g20604_i0 | PRJNA902848 | 20654 | 205 | 15.371212 | 31.5109846 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 377 | 2.6e-100 | NTclustered | gi|291495599|gb|GU823226.1| | 152704 | g20604 | i0 | 100 | 99.5121951219512 | 204 | 0 | 99 | 0 | 1 | 204 | 857 | 1060 | Uncultured stramenopile clone BCA5F13RJ3F09 18S ribosomal RNA gene, partial sequence | blastn | 20400 | 377 | 1 | Eukaryota | Sar | uncultured stramenopile | |||||||
| 20008616 | 20008616 | PRJNA902848_P_NODE_18276_length_245_cov_0.906977_g18226_i0 | PRJNA902848 | 18276 | 245 | 0.906977 | 2.22209365 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 7.46e-47 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g18226 | i0 | 82.449 | 25.7142857142857 | 245 | 28 | 99 | 11 | 2 | 243 | 3777 | 4009 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 6300 | 200 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 20008853 | 20008853 | PRJNA902848_P_NODE_996_length_672_cov_8.966611_g949_i0 | PRJNA902848 | 996 | 672 | 8.966611 | 60.25562592 | Frontonia paramagna | 1590102 | SAR_Eukaryotes | SAR_Eukaryotes | 518 | 5.49e-142 | NTclustered | gi|1908106363|gb|MW031798.1| | 1590102 | g949 | i0 | 89.423 | 87.9136904761905 | 416 | 37 | 91 | 7 | 223 | 638 | 1435 | 1843 | Frontonia paramagna isolate SM2017091201 large subunit ribosomal RNA gene, partial sequence | blastn | 59078 | 518 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Frontoniidae | Frontonia | Frontonia paramagna | ||
| 20373322 | 20373322 | PRJNA902848_P_NODE_2016_length_518_cov_7.649438_g1967_i0 | PRJNA902848 | 2016 | 518 | 7.649438 | 39.62408884 | Colpoda | 5979 | SAR_Eukaryotes | SAR_Eukaryotes | 953 | 0 | NTclustered | gi|1802599797|gb|MT001206.1| | 41631 | g1967 | i0 | 100 | 99.6216216216216 | 516 | 0 | 99 | 0 | 1 | 516 | 509 | 1024 | Colpoda sp. strain HFCC1227 small subunit ribosomal RNA gene, partial sequence | blastn | 51604 | 953 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 23833987 | 23833987 | PRJNA902848_P_NODE_11639_length_267_cov_0.891753_g11589_i0 | PRJNA902848 | 11639 | 267 | 0.891753 | 2.38098051 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 6.07e-83 | NTclustered | gi|238617604|gb|FJ973379.1| | 646463 | g11589 | i0 | 89.535 | 87.1198501872659 | 258 | 20 | 96 | 5 | 12 | 267 | 715 | 967 | Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence | blastn | 23261 | 320 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 25108151 | 25108151 | PRJNA902848_P_NODE_540_length_847_cov_10.018088_g498_i0 | PRJNA902848 | 540 | 847 | 10.018088 | 84.85320536 | Ochromonas sp. SAG 933.10 | 984272 | SAR_Eukaryotes | SAR_Eukaryotes | 1330 | 0 | NTclustered | gi|323690578|gb|GU935637.1| | 984272 | g498 | i0 | 95.065 | 86.2290436835891 | 851 | 33 | 99 | 7 | 1 | 846 | 1160 | 2006 | Ochromonas sp. SAG 933.10 28S ribosomal RNA gene, partial sequence | blastn | 73036 | 1330 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Ochromonas | Ochromonas sp. SAG 933.10 |
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);;