contig_metadata
20 rows where bioproject = "PRJNA795663" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 779305 | 779305 | PRJNA795663_S_NODE_1481_length_455_cov_24.918660_g1376_i0 | PRJNA795663 | 1481 | 455 | 24.91866 | 113.379903 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 752 | 0 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g1376 | i0 | 96.696 | 99.9626373626374 | 454 | 12 | 99 | 3 | 1 | 452 | 1951 | 1499 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 45483 | 752 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 4607613 | 4607613 | PRJNA795663_S_NODE_10164_length_191_cov_49.012987_g10059_i0 | PRJNA795663 | 10164 | 191 | 49.012987 | 93.61480517 | Paracercomonas crassicauda | 466266 | SAR_Eukaryotes | SAR_Eukaryotes | 327 | 2.44e-85 | NTclustered | gi|262262832|gb|FJ790725.1| | 466266 | g10059 | i0 | 98.907 | 96.261780104712 | 183 | 2 | 96 | 0 | 9 | 191 | 1275 | 1457 | Paracercomonas crassicauda strain ATCC 50316 18S ribosomal RNA gene, partial sequence | blastn | 18386 | 327 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas crassicauda | |||
| 5882887 | 5882887 | PRJNA795663_S_NODE_15085_length_163_cov_15.365079_g14980_i0 | PRJNA795663 | 15085 | 163 | 15.365079 | 25.04507877 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 5.68e-76 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g14980 | i0 | 99.387 | 100.478527607362 | 163 | 1 | 100 | 0 | 1 | 163 | 1532 | 1370 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 16378 | 296 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 7157902 | 7157902 | PRJNA795663_S_NODE_806_length_588_cov_9.226860_g717_i0 | PRJNA795663 | 806 | 588 | 9.22686 | 54.2539368 | Labyrinthula diatomea | 2590897 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 1.2099999999999999e-23 | NTclustered | gi|1693864506|gb|MN101174.1| | 2590897 | g717 | i0 | 84.375 | 0.518707482993197 | 128 | 18 | 22 | 2 | 214 | 341 | 3731 | 3856 | Labyrinthula diatomea strain Thailand-2017 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 | 305 | 124 | 1 | Eukaryota | Sar | Bigyra | Labyrinthulida | Labyrinthulaceae | Labyrinthula | Labyrinthula diatomea | |||
| 9707460 | 9707460 | PRJNA795663_S_NODE_10208_length_191_cov_2.168831_g10103_i0 | PRJNA795663 | 10208 | 191 | 2.168831 | 4.14246721 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 8.89e-75 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g10103 | i0 | 94.301 | 7.03141361256545 | 193 | 7 | 100 | 3 | 1 | 191 | 353 | 163 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 1343 | 292 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 9707772 | 9707772 | PRJNA795663_S_NODE_8788_length_203_cov_7.524096_g8683_i0 | PRJNA795663 | 8788 | 203 | 7.524096 | 15.27391488 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 326 | 9.44e-85 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g8683 | i0 | 98.378 | 91.1625615763547 | 185 | 3 | 91 | 0 | 1 | 185 | 1393 | 1209 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 18506 | 326 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 10144797 | 10144797 | PRJNA795663_S_NODE_12328_length_177_cov_13.278571_g12223_i0 | PRJNA795663 | 12328 | 177 | 13.278571 | 23.50307067 | Cercomonadidae | 45108 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 2.87e-84 | NTclustered | gi|1695780|gb|U42448.1|CAU42448 | 45110 | g12223 | i0 | 99.435 | 98.4519774011299 | 177 | 1 | 100 | 0 | 1 | 177 | 606 | 782 | Cercomonas ATCC50316 18S ribosomal RNA gene, complete sequence | blastn | 17426 | 327 | 0.990825688073395 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. ATCC 50316 | |||
| 11420285 | 11420285 | PRJNA795663_S_NODE_5889_length_242_cov_5.048780_g5784_i0 | PRJNA795663 | 5889 | 242 | 5.04878 | 12.2180476 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 388 | 1.46e-103 | NTclustered | gi|363412153|gb|JN120227.1| | 60850 | g5784 | i0 | 100 | 86.7768595041322 | 210 | 0 | 87 | 0 | 19 | 228 | 1258 | 1467 | Vorticella convallaria isolate 96Vorsp16 18S ribosomal RNA gene, partial sequence | blastn | 21000 | 388 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella convallaria | ||
| 11420304 | 11420304 | PRJNA795663_S_NODE_7709_length_215_cov_3.022472_g7604_i0 | PRJNA795663 | 7709 | 215 | 3.022472 | 6.4983148 | Cercomonadidae | 45108 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 2.7699999999999993e-95 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g7604 | i0 | 100 | 91.3209302325581 | 195 | 0 | 91 | 0 | 21 | 215 | 1021 | 1215 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 19634 | 361 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 12258913 | 12258913 | PRJNA795663_S_NODE_18630_length_151_cov_1.535088_g18525_i0 | PRJNA795663 | 18630 | 151 | 1.535088 | 2.31798288 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 9.33e-19 | NTclustered | gi|820691464|tpe|LN714483.1| | 572307 | g18525 | i0 | 81.295 | 3.16556291390728 | 139 | 18 | 89 | 5 | 1 | 135 | 5011708 | 5011842 | TPA_asm: Neospora caninum Liverpool, chromosome chrVIII, complete genome | blastn | 478 | 106 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 13532907 | 13532907 | PRJNA795663_S_NODE_1211_length_494_cov_161.916849_g1109_i0 | PRJNA795663 | 1211 | 494 | 161.916849 | 799.86923406 | Cercomonas sp. HFCC540 | 458868 | SAR_Eukaryotes | SAR_Eukaryotes | 440 | 8.809999999999997e-119 | NTclustered | gi|161015708|gb|EF681942.1| | 458868 | g1109 | i0 | 84.479 | 36.4251012145749 | 451 | 65 | 91 | 5 | 26 | 474 | 686 | 239 | Cercomonas sp. HFCC540 28S ribosomal RNA gene, partial sequence | blastn | 17994 | 440 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC540 | |||
| 16081914 | 16081914 | PRJNA795663_S_NODE_2573_length_353_cov_14.348101_g2468_i0 | PRJNA795663 | 2573 | 353 | 14.348101 | 50.64879653 | Paracercomonas crassicauda | 466266 | SAR_Eukaryotes | SAR_Eukaryotes | 652 | 0 | NTclustered | gi|262262832|gb|FJ790725.1| | 466266 | g2468 | i0 | 100 | 98.3512747875354 | 353 | 0 | 100 | 0 | 1 | 353 | 384 | 32 | Paracercomonas crassicauda strain ATCC 50316 18S ribosomal RNA gene, partial sequence | blastn | 34718 | 652 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas crassicauda | |||
| 22456725 | 22456725 | PRJNA795663_S_NODE_9438_length_197_cov_4.518750_g9333_i0 | PRJNA795663 | 9438 | 197 | 4.51875 | 8.9019375 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 9.17e-80 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g9333 | i0 | 94.949 | 170.091370558376 | 198 | 9 | 100 | 1 | 1 | 197 | 2506 | 2703 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 33508 | 309 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 22894015 | 22894015 | PRJNA795663_S_NODE_4338_length_279_cov_29.479339_g4233_i0 | PRJNA795663 | 4338 | 279 | 29.479339 | 82.24735581 | Paracercomonas | 372085 | SAR_Eukaryotes | SAR_Eukaryotes | 468 | 2.15e-127 | NTclustered | gi|262262832|gb|FJ790725.1| | 466266 | g4233 | i0 | 99.609 | 91.7956989247312 | 256 | 1 | 92 | 0 | 24 | 279 | 752 | 1007 | Paracercomonas crassicauda strain ATCC 50316 18S ribosomal RNA gene, partial sequence | blastn | 25611 | 468 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas crassicauda | |||
| 23732118 | 23732118 | PRJNA795663_S_NODE_13039_length_173_cov_4.823529_g12934_i0 | PRJNA795663 | 13039 | 173 | 4.823529 | 8.34470517 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 3.61e-83 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g12934 | i0 | 100 | 100.768786127168 | 173 | 0 | 100 | 0 | 1 | 173 | 2725 | 2897 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 17433 | 320 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 25005859 | 25005859 | PRJNA795663_S_NODE_4020_length_288_cov_32.661355_g3915_i0 | PRJNA795663 | 4020 | 288 | 32.661355 | 94.0647024 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 375 | 1.3899999999999998e-99 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g3915 | i0 | 92.135 | 55.2326388888889 | 267 | 19 | 92 | 2 | 24 | 288 | 1953 | 2219 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 15907 | 375 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 28348676 | 28348676 | PRJNA795663_S_NODE_6466_length_232_cov_2.446154_g6361_i0 | PRJNA795663 | 6466 | 232 | 2.446154 | 5.67507728 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 7.7e-7 | NR | CEP01997.1 | 37360 | g6361 | i0 | 50 | 0.931034482758621 | 72 | 36 | 93.1 | 0 | 2 | 217 | 132 | 203 | CEP01997.1 hypothetical protein PBRA_002262 [Plasmodiophora brassicae] | diamond | 216 | 55.1 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28569648 | 28569648 | PRJNA795663_S_NODE_8587_length_206_cov_1.449704_g8482_i0 | PRJNA795663 | 8587 | 206 | 1.449704 | 2.98639024 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 78.6 | 5.37e-15 | NR | CEO96163.1 | 37360 | g8482 | i0 | 71.4 | 1.48543689320388 | 49 | 14 | 71.4 | 0 | 204 | 58 | 206 | 254 | CEO96163.1 hypothetical protein PBRA_004853 [Plasmodiophora brassicae] | diamond | 306 | 78.6 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28853679 | 28853679 | PRJNA795663_S_NODE_11228_length_184_cov_2.006803_g11123_i0 | PRJNA795663 | 11228 | 184 | 2.006803 | 3.69251752 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 91.3 | 2.7100000000000004e-21 | NR | CAG9318382.1 | 1481888 | g11123 | i0 | 60.7 | 0.994565217391304 | 61 | 24 | 99.5 | 0 | 183 | 1 | 65 | 125 | CAG9318382.1 unnamed protein product [Blepharisma stoltei] | diamond | 183 | 91.3 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 32235480 | 32235480 | PRJNA795663_S_NODE_13838_length_169_cov_2.015152_g13733_i0 | PRJNA795663 | 13838 | 169 | 2.015152 | 3.40560688 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 79 | 2.77e-16 | NR | CEP01997.1 | 37360 | g13733 | i0 | 64.3 | 4.91715976331361 | 56 | 20 | 99.4 | 0 | 168 | 1 | 13 | 68 | CEP01997.1 hypothetical protein PBRA_002262 [Plasmodiophora brassicae] | diamond | 831 | 79 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae |
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);;