contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA749559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 725958 | 725958 | PRJNA749559_P_NODE_2561_length_271_cov_6.100000_g2491_i0 | PRJNA749559 | 2561 | 271 | 6.1 | 16.531 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 473 | 4.4799999999999996e-129 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g2491 | i0 | 98.155 | 100.409594095941 | 271 | 5 | 100 | 0 | 1 | 271 | 666 | 936 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 27211 | 473 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 3277333 | 3277333 | PRJNA749559_P_NODE_5083_length_200_cov_2.158273_g5013_i0 | PRJNA749559 | 5083 | 200 | 2.158273 | 4.316546 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.1800000000000003e-21 | NTclustered | gi|829192014|ref|XM_012799966.1| | 312017 | g5013 | i0 | 88.421 | 2.1 | 95 | 11 | 48 | 0 | 48 | 142 | 125 | 219 | Tetrahymena thermophila SB210 hypothetical protein partial mRNA | blastn | 420 | 115 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 4554457 | 4554457 | PRJNA749559_P_NODE_1904_length_317_cov_5.437500_g1834_i0 | PRJNA749559 | 1904 | 317 | 5.4375 | 17.236875 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 586 | 6.579999999999998e-163 | NTclustered | gi|1202135013|gb|KY476314.1| | 151077 | g1834 | i0 | 100 | 99.4069400630915 | 317 | 0 | 100 | 0 | 1 | 317 | 365 | 49 | Chilodonella uncinata 18S ribosomal RNA gene, partial sequence | blastn | 31512 | 586 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 5028134 | 5028134 | PRJNA749559_P_NODE_1824_length_327_cov_4.481203_g1754_i0 | PRJNA749559 | 1824 | 327 | 4.481203 | 14.65353381 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 577 | 4.099999999999999e-160 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g1754 | i0 | 98.471 | 100.938837920489 | 327 | 5 | 100 | 0 | 1 | 327 | 2688 | 2362 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 33007 | 577 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 7104649 | 7104649 | PRJNA749559_P_NODE_2086_length_302_cov_1.062241_g2016_i0 | PRJNA749559 | 2086 | 302 | 1.062241 | 3.20796782 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 492 | 1.4e-134 | NTclustered | gi|347439291|gb|JN111994.1| | 151077 | g2016 | i0 | 96.026 | 99.5860927152318 | 302 | 12 | 100 | 0 | 1 | 302 | 943 | 642 | Chilodonella uncinata strain Pol alpha-tubulin (atub) gene, partial cds; macronuclear | blastn | 30075 | 492 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 12679498 | 12679498 | PRJNA749559_P_NODE_3210_length_241_cov_1.422222_g3140_i0 | PRJNA749559 | 3210 | 241 | 1.422222 | 3.42755502 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|698813671|ref|XM_009841563.1| | 112090 | g3140 | i0 | 100 | 0.601659751037344 | 29 | 0 | 12 | 0 | 13 | 41 | 502 | 474 | Aphanomyces astaci hypothetical protein mRNA | blastn | 145 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 13479776 | 13479776 | PRJNA749559_P_NODE_291_length_886_cov_7.200000_g241_i0 | PRJNA749559 | 291 | 886 | 7.2 | 63.792 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 1498 | 0 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g241 | i0 | 97.185 | 61.4345372460497 | 888 | 22 | 100 | 3 | 1 | 886 | 1479 | 2365 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 54431 | 1498 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 16028632 | 16028632 | PRJNA749559_P_NODE_533_length_657_cov_9.048658_g467_i0 | PRJNA749559 | 533 | 657 | 9.048658 | 59.44968306 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 1092 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g467 | i0 | 96.651 | 61.8188736681887 | 657 | 22 | 100 | 0 | 1 | 657 | 665 | 9 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 40615 | 1092 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 18577693 | 18577693 | PRJNA749559_P_NODE_5155_length_193_cov_3.310606_g5085_i0 | PRJNA749559 | 5155 | 193 | 3.310606 | 6.38946958 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 335 | 1.48e-87 | NTclustered | gi|300676714|gb|GQ377691.1| | 151077 | g5085 | i0 | 97.927 | 57.6424870466321 | 193 | 4 | 100 | 0 | 1 | 193 | 24 | 216 | Chilodonella uncinata rps22a (rps22a) mRNA, complete cds | blastn | 11125 | 335 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 22403360 | 22403360 | PRJNA749559_P_NODE_2318_length_286_cov_1.422222_g2248_i0 | PRJNA749559 | 2318 | 286 | 1.422222 | 4.06755492 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 501 | 2.18e-137 | NTclustered | gi|110644972|gb|DQ665918.1| | 151077 | g2248 | i0 | 98.252 | 96.7622377622378 | 286 | 5 | 100 | 0 | 1 | 286 | 675 | 390 | Chilodonella uncinata clone 1 beta-tubulin gene, partial cds | blastn | 27674 | 501 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 22877408 | 22877408 | PRJNA749559_P_NODE_1538_length_359_cov_2.550336_g1468_i0 | PRJNA749559 | 1538 | 359 | 2.550336 | 9.15570624 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 8.75e-58 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g1468 | i0 | 97.143 | 1.16991643454039 | 140 | 4 | 39 | 0 | 1 | 140 | 2943 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 420 | 237 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola |
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);;