contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA674308" and tax_phylum = "Ciliophora"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7023276 | 7023276 | PRJNA674308_P_NODE_16186_length_241_cov_1.369792_g15951_i0 | PRJNA674308 | 16186 | 241 | 1.369792 | 3.30119872 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 4.1099999999999997e-94 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g15951 | i0 | 93.388 | 61.4273858921162 | 242 | 14 | 100 | 2 | 1 | 241 | 3397 | 3637 | Colpoda sp. isolate CIL1 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 | 14804 | 357 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 7544328 | 7544328 | PRJNA674308_P_NODE_1546_length_807_cov_7.915567_g1355_i0 | PRJNA674308 | 1546 | 807 | 7.915567 | 63.87862569 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 1356 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g1355 | i0 | 97.022 | 51.2552664188352 | 806 | 24 | 99 | 0 | 1 | 806 | 10 | 815 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 41363 | 1356 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 10848991 | 10848991 | PRJNA674308_P_NODE_8269_length_331_cov_1.599291_g8034_i0 | PRJNA674308 | 8269 | 331 | 1.599291 | 5.29365321 | Paramecium caudatum | 5885 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.81e-24 | NTclustered | gi|299830252|ref|NC_014262.1| | 5885 | g8034 | i0 | 76.357 | 4.18126888217523 | 258 | 48 | 75 | 9 | 1 | 247 | 1235 | 1490 | Paramecium caudatum mitochondrion, complete genome | blastn | 1384 | 126 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium caudatum | ||
| 11369987 | 11369987 | PRJNA674308_P_NODE_14329_length_254_cov_21.639024_g14094_i0 | PRJNA674308 | 14329 | 254 | 21.639024 | 54.96312096 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.18e-114 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g14094 | i0 | 96.85 | 9.14566929133858 | 254 | 8 | 100 | 0 | 1 | 254 | 1531 | 1784 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 2323 | 425 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 13920650 | 13920650 | PRJNA674308_P_NODE_46811_length_164_cov_29.052174_g46576_i0 | PRJNA674308 | 46811 | 164 | 29.052174 | 47.64556536 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 3.42e-78 | NTclustered | gi|158147318|gb|EU047813.1| | 151077 | g46576 | i0 | 100 | 71.1707317073171 | 164 | 0 | 100 | 0 | 1 | 164 | 254 | 91 | Chilodonella uncinata strain ATCC 50194 5.8S ribosomal RNA gene and internal transcribed spacer 2, partial sequence; macronuclear | blastn | 11672 | 303 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 14673754 | 14673754 | PRJNA674308_P_NODE_2972_length_564_cov_2.429126_g2742_i0 | PRJNA674308 | 2972 | 564 | 2.429126 | 13.70027064 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 833 | 0 | NTclustered | gi|347439270|gb|JN111983.1| | 151077 | g2742 | i0 | 93.451 | 31.6010638297872 | 565 | 32 | 99 | 5 | 1 | 562 | 340 | 902 | Chilodonella uncinata strain USA_SC2 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 17823 | 833 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 15947323 | 15947323 | PRJNA674308_P_NODE_22193_length_210_cov_4.155280_g21958_i0 | PRJNA674308 | 22193 | 210 | 4.15528 | 8.726088 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 366 | 5.7900000000000005e-97 | NTclustered | gi|1202135013|gb|KY476314.1| | 151077 | g21958 | i0 | 98.095 | 99.6714285714286 | 210 | 4 | 100 | 0 | 1 | 210 | 297 | 88 | Chilodonella uncinata 18S ribosomal RNA gene, partial sequence | blastn | 20931 | 366 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 16469600 | 16469600 | PRJNA674308_P_NODE_7393_length_349_cov_23.080000_g7158_i0 | PRJNA674308 | 7393 | 349 | 23.08 | 80.5492 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 4e-46 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g7158 | i0 | 96.639 | 1.02292263610315 | 119 | 4 | 34 | 0 | 1 | 119 | 2964 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 357 | 198 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 17222786 | 17222786 | PRJNA674308_P_NODE_27174_length_192_cov_2.545455_g26939_i0 | PRJNA674308 | 27174 | 192 | 2.545455 | 4.8872736 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 327 | 2.45e-85 | NTclustered | gi|1134929563|gb|KY508246.1| | 151077 | g26939 | i0 | 97.861 | 15.9739583333333 | 187 | 4 | 97 | 0 | 4 | 190 | 208 | 22 | Chilodonella uncinata isolate EL small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 3067 | 327 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata |
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);;