contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJDB4470" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1284176 | 1284176 | PRJDB4470_P_NODE_89402_length_184_cov_1.007407_g88247_i0 | PRJDB4470 | 89402 | 184 | 1.007407 | 1.85362888 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 1.4499999999999998e-57 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g88247 | i0 | 95.302 | 37.3152173913044 | 149 | 5 | 100 | 2 | 1 | 149 | 300046 | 299900 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 6866 | 235 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 2256622 | 2256622 | PRJDB4470_P_NODE_65382_length_233_cov_1.413043_g64227_i0 | PRJDB4470 | 65382 | 233 | 1.413043 | 3.29239019 | Litostomatea | 5988 | SAR_Eukaryotes | SAR_Eukaryotes | 348 | 2.37e-91 | NTclustered | gi|1226859313|gb|MF474356.1| | 394801 | g64227 | i0 | 93.59 | 72.519313304721 | 234 | 13 | 100 | 2 | 1 | 233 | 1334 | 1566 | Lacrymaria marina isolate QZS2013110504 large subunit ribosomal RNA gene, partial sequence | blastn | 16897 | 348 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Haptorida | Lacrymariidae | Lacrymaria | Lacrymaria marina | ||
| 2558941 | 2558941 | PRJDB4470_P_NODE_107283_length_166_cov_0.888889_g106128_i0 | PRJDB4470 | 107283 | 166 | 0.888889 | 1.47555574 | Helkesimastix marina | 645121 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 2.69e-79 | NTclustered | gi|237687967|gb|FJ410915.1| | 645121 | g106128 | i0 | 100 | 54.1144578313253 | 166 | 0 | 100 | 0 | 1 | 166 | 1516 | 1351 | Helkesimastix sp. ATCC 50328 18S ribosomal RNA gene, partial sequence | blastn | 8983 | 307 | 1 | Eukaryota | Sar | Cercozoa | Helkesimastigidae | Helkesimastix | Helkesimastix marina | ||||
| 2559641 | 2559641 | PRJDB4470_P_NODE_74263_length_211_cov_1.185185_g73108_i0 | PRJDB4470 | 74263 | 211 | 1.185185 | 2.50074035 | Minutocellus polymorphus | 265543 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 2.99e-25 | NTclustered | gi|2632235292|gb|OR922674.1| | 265543 | g73108 | i0 | 94.118 | 34.4502369668246 | 85 | 4 | 40 | 1 | 1 | 84 | 3982 | 4066 | Minutocellus polymorphus strain AGSB0025 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 | 7269 | 128 | 1 | Eukaryota | Sar | Bacillariophyta | Mediophyceae | Cymatosirales | Cymatosiraceae | Minutocellus | Minutocellus polymorphus | ||
| 3531991 | 3531991 | PRJDB4470_P_NODE_55403_length_267_cov_0.935780_g54248_i0 | PRJDB4470 | 55403 | 267 | 0.93578 | 2.4985326 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 333 | 7.789999999999999e-87 | NTclustered | gi|325181427|emb|FR824061.1| | 890382 | g54248 | i0 | 89.219 | 2.01498127340824 | 269 | 25 | 100 | 4 | 1 | 267 | 114706 | 114972 | Albugo laibachii Nc14, genomic contig CONTIG_16_NC14_v4_210924_216 | blastn | 538 | 333 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 3835700 | 3835700 | PRJDB4470_P_NODE_46024_length_309_cov_3.607692_g44871_i0 | PRJDB4470 | 46024 | 309 | 3.607692 | 11.14776828 | Leukarachnion sp. ATCC PRA-24 | 568390 | SAR_Eukaryotes | SAR_Eukaryotes | 385 | 2.499999999999999e-102 | NTclustered | gi|2727570083|gb|PP760457.1| | 568390 | g44871 | i0 | 90.169 | 49.5339805825243 | 295 | 29 | 95 | 0 | 14 | 308 | 40005 | 39711 | Leukarachnion sp. ATCC PRA-24 culture ATCC:BJ-24B2 mitochondrion, complete genome | blastn | 15306 | 385 | 1 | Eukaryota | Sar | Leukarachnion sp. ATCC PRA-24 | |||||||
| 3835916 | 3835916 | PRJDB4470_P_NODE_71984_length_216_cov_1.197605_g70829_i0 | PRJDB4470 | 71984 | 216 | 1.197605 | 2.5868268 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 3.61e-94 | NTclustered | gi|1624698154|ref|XM_029013945.1| | 189622 | g70829 | i0 | 96.759 | 29.4814814814815 | 216 | 4 | 100 | 2 | 1 | 216 | 90 | 302 | Babesia ovata vWA domain-like family protein, putative (BOVATA_050280), partial mRNA | blastn | 6368 | 357 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 4809146 | 4809146 | PRJDB4470_P_NODE_107064_length_166_cov_0.888889_g105909_i0 | PRJDB4470 | 107064 | 166 | 0.888889 | 1.47555574 | root | 1 | Root_unresolved | Root_unresolved | 307 | 2.69e-79 | NTclustered | gi|166044505|emb|CU367414.1| | 100861 | g105909 | i0 | 100 | 81.2831325301205 | 166 | 0 | 100 | 0 | 1 | 166 | 344 | 509 | Aphanomyces euteiches cDNA | blastn | 13493 | 307 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 5111851 | 5111851 | PRJDB4470_P_NODE_34425_length_382_cov_9.315315_g33276_i0 | PRJDB4470 | 34425 | 382 | 9.315315 | 35.5845033 | Dysteria brasiliensis | 497733 | SAR_Eukaryotes | SAR_Eukaryotes | 311 | 5.4400000000000005e-80 | NTclustered | gi|1216628402|gb|KX099196.1| | 497733 | g33276 | i0 | 84.858 | 69.9528795811518 | 317 | 38 | 82 | 7 | 1 | 312 | 312 | 1 | Dysteria brasiliensis clone DB3 28S ribosomal RNA gene, partial sequence | blastn | 26722 | 311 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Dysteriida | Dysteriidae | Dysteria | Dysteria brasiliensis | ||
| 6084624 | 6084624 | PRJDB4470_P_NODE_98425_length_171_cov_2.090164_g97270_i0 | PRJDB4470 | 98425 | 171 | 2.090164 | 3.57418044 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.004 | NTclustered | gi|117575160|emb|AM055942.3| | 383379 | g97270 | i0 | 94.444 | 4.33333333333333 | 36 | 1 | 20 | 1 | 52 | 86 | 773073 | 773108 | Toxoplasma gondii RH, genomic DNA chromosome Ia | blastn | 741 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 6387885 | 6387885 | PRJDB4470_P_NODE_55486_length_266_cov_2.635945_g54331_i0 | PRJDB4470 | 55486 | 266 | 2.635945 | 7.0116137 | Chaetoceros similis | 1366869 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 8.5e-22 | NTclustered | gi|2632235327|gb|OR922709.1| | 1366869 | g54331 | i0 | 84.746 | 3.07518796992481 | 118 | 17 | 44 | 1 | 149 | 266 | 3932 | 4048 | Chaetoceros similis strain AGSB0114 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 | 818 | 117 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Chaetocerotales | Chaetocerotaceae | Chaetoceros | Chaetoceros similis | ||
| 7661608 | 7661608 | PRJDB4470_P_NODE_21947_length_509_cov_4.202174_g20828_i0 | PRJDB4470 | 21947 | 509 | 4.202174 | 21.38906566 | Phaeodactylum tricornutum | 2850 | SAR_Eukaryotes | SAR_Eukaryotes | 743 | 0 | NTclustered | gi|146762526|gb|EF553458.1| | 2850 | g20828 | i0 | 93.124 | 100.318271119843 | 509 | 32 | 99 | 3 | 2 | 509 | 4571 | 4065 | Phaeodactylum tricornutum strain CCAP 1055/1 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 | 51062 | 743 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Phaeodactylaceae | Phaeodactylum | Phaeodactylum tricornutum | ||
| 7661695 | 7661695 | PRJDB4470_P_NODE_30327_length_416_cov_3.686649_g29185_i0 | PRJDB4470 | 30327 | 416 | 3.686649 | 15.33645984 | Nitzschia sp. (in: diatoms) | 1884248 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 2.32e-24 | NTclustered | gi|2632235302|gb|OR922684.1| | 1884248 | g29185 | i0 | 87.273 | 0.264423076923077 | 110 | 14 | 26 | 0 | 204 | 313 | 3592 | 3483 | Nitzschia sp. (in: diatoms) strain AGSB0041 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 | 110 | 126 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Nitzschia | Nitzschia sp. (in: diatoms) | ||
| 7661951 | 7661951 | PRJDB4470_P_NODE_56867_length_261_cov_1.948113_g55712_i0 | PRJDB4470 | 56867 | 261 | 1.948113 | 5.08457493 | Lagenidium deciduum | 884619 | SAR_Eukaryotes | SAR_Eukaryotes | 442 | 1.2099999999999994e-119 | NTclustered | gi|320578977|gb|HQ395660.1| | 884619 | g55712 | i0 | 99.587 | 95.2643678160919 | 242 | 1 | 93 | 0 | 20 | 261 | 3 | 244 | Lagenidium sp. PWL-2010c strain CBS 127042 28S ribosomal RNA gene, partial sequence | blastn | 24864 | 442 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium deciduum | ||
| 8634537 | 8634537 | PRJDB4470_P_NODE_86887_length_187_cov_1.884058_g85732_i0 | PRJDB4470 | 86887 | 187 | 1.884058 | 3.52318846 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 315 | 1.85e-81 | NTclustered | gi|33520249|gb|AY273994.1| | 127444 | g85732 | i0 | 97.297 | 99.7647058823529 | 185 | 5 | 99 | 0 | 3 | 187 | 258 | 442 | Pythium undulatum large subunit ribosomal RNA gene, partial sequence | blastn | 18656 | 318 | 0.990566037735849 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Elongisporangium | Elongisporangium undulatum | ||
| 8936859 | 8936859 | PRJDB4470_P_NODE_88408_length_185_cov_1.500000_g87253_i0 | PRJDB4470 | 88408 | 185 | 1.5 | 2.775 | Tetrahymena rostrata | 5909 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 6.61e-76 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g87253 | i0 | 100 | 83.3351351351351 | 160 | 0 | 86 | 0 | 26 | 185 | 4204 | 4363 | Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 15417 | 296 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 10212536 | 10212536 | PRJDB4470_P_NODE_65009_length_234_cov_1.664865_g63854_i0 | PRJDB4470 | 65009 | 234 | 1.664865 | 3.8957841 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|829099384|ref|XM_971547.2| | 312017 | g63854 | i0 | 100 | 0.123931623931624 | 29 | 0 | 12 | 0 | 69 | 97 | 1809 | 1837 | Tetrahymena thermophila SB210 MIR domain protein partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 10212802 | 10212802 | PRJDB4470_P_NODE_97749_length_172_cov_1.658537_g96594_i0 | PRJDB4470 | 97749 | 172 | 1.658537 | 2.85268364 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.014 | NTclustered | gi|145505128|ref|XM_001438494.1| | 5888 | g96594 | i0 | 100 | 0.325581395348837 | 28 | 0 | 16 | 0 | 112 | 139 | 294 | 267 | Paramecium tetraurelia uncharacterized protein (GSPATT00000846001), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 15311783 | 15311783 | PRJDB4470_P_NODE_54433_length_270_cov_7.113122_g53278_i0 | PRJDB4470 | 54433 | 270 | 7.113122 | 19.2054294 | Mayamaea permitis | 1302819 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 7.84e-92 | NTclustered | gi|168145888|emb|AM710524.1| | 1302819 | g53278 | i0 | 91.732 | 92.862962962963 | 254 | 17 | 94 | 3 | 1 | 254 | 294 | 45 | Mayamaea atomus var. permitis partial 28S rRNA gene, strain AT-101Gel04 | blastn | 25073 | 350 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculaceae | Mayamaea | Mayamaea permitis | ||
| 16284074 | 16284074 | PRJDB4470_P_NODE_78693_length_201_cov_3.203947_g77538_i0 | PRJDB4470 | 78693 | 201 | 3.203947 | 6.43993347 | root | 1 | Root_unresolved | Root_unresolved | 337 | 4.309999999999999e-88 | NTclustered | gi|10832|emb|X54512.1| | 5911 | g77538 | i0 | 100 | 84.5970149253731 | 182 | 0 | 91 | 0 | 20 | 201 | 8128 | 8309 | T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA | blastn | 17004 | 337 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 19134891 | 19134891 | PRJDB4470_P_NODE_27176_length_447_cov_42.331658_g26038_i0 | PRJDB4470 | 27176 | 447 | 42.331658 | 189.22251126 | Epistylis sp. 6 | 2979169 | SAR_Eukaryotes | SAR_Eukaryotes | 702 | 0 | NTclustered | gi|2304601482|gb|OP458303.1| | 2979169 | g26038 | i0 | 98.254 | 88.2170022371365 | 401 | 7 | 90 | 0 | 47 | 447 | 1 | 401 | Epistylis sp. 6 large subunit ribosomal RNA gene, partial sequence | blastn | 39433 | 702 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Epistylidae | Epistylis | Epistylis sp. 6 | ||
| 20410385 | 20410385 | PRJDB4470_P_NODE_72157_length_215_cov_2.463855_g71002_i0 | PRJDB4470 | 72157 | 215 | 2.463855 | 5.29728825 | Paramecium caudatum | 5885 | SAR_Eukaryotes | SAR_Eukaryotes | 359 | 9.969999999999999e-95 | NTclustered | gi|299830252|ref|NC_014262.1| | 5885 | g71002 | i0 | 100 | 30.3720930232558 | 194 | 0 | 90 | 0 | 22 | 215 | 15220 | 15027 | Paramecium caudatum mitochondrion, complete genome | blastn | 6530 | 359 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium caudatum | ||
| 22658196 | 22658196 | PRJDB4470_P_NODE_100838_length_169_cov_0.866667_g99683_i0 | PRJDB4470 | 100838 | 169 | 0.866667 | 1.46466723 | Poterioochromonas | 88166 | SAR_Eukaryotes | SAR_Eukaryotes | 302 | 1.27e-77 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g99683 | i0 | 100 | 88.6272189349112 | 163 | 0 | 96 | 0 | 7 | 169 | 1724 | 1562 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 14978 | 302 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 24235537 | 24235537 | PRJDB4470_P_NODE_63740_length_238_cov_1.333333_g62585_i0 | PRJDB4470 | 63740 | 238 | 1.333333 | 3.17333254 | Attheya longicornis | 451786 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 2.71e-16 | NTclustered | gi|2046217437|gb|MW729336.1| | 451786 | g62585 | i0 | 78.808 | 5.16806722689076 | 151 | 28 | 62 | 4 | 91 | 238 | 38496 | 38347 | Attheya longicornis mitochondrion, complete genome | blastn | 1230 | 99 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Chaetocerotales | Attheyaceae | Attheya | Attheya longicornis |
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);;