contig_metadata
7 rows where bioproject = "PRJEB56699" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3542563 | 3542563 | PRJEB56699_P_NODE_1303_length_516_cov_4.870637_g1109_i0 | PRJEB56699 | 1303 | 516 | 4.870637 | 25.13248692 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 682 | 0 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g1109 | i0 | 94.831 | 85.0833333333333 | 445 | 10 | 86 | 3 | 1 | 444 | 2605 | 3037 | 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 | 43903 | 682 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 14153012 | 14153012 | PRJEB56699_P_NODE_1292_length_518_cov_4.494888_g1098_i0 | PRJEB56699 | 1292 | 518 | 4.494888 | 23.28351984 | Coleps hirtus | 60000 | SAR_Eukaryotes | SAR_Eukaryotes | 475 | 2.5399999999999993e-129 | NTclustered | gi|328684911|gb|HM122027.1| | 394492 | g1098 | i0 | 94.481 | 12.8745173745174 | 308 | 17 | 59 | 0 | 93 | 400 | 521 | 214 | Coleps hirtus hirtus isolate SNK09101903 macronuclear | blastn | 6669 | 475 | 1 | Eukaryota | Sar | Ciliophora | Prostomatea | Prorodontida | Colepidae | Coleps | Coleps hirtus | ||
| 16701320 | 16701320 | PRJEB56699_P_NODE_4234_length_237_cov_2.187500_g4004_i0 | PRJEB56699 | 4234 | 237 | 2.1875 | 5.184375 | Euplotes vanleeuwenhoeki | 2794224 | SAR_Eukaryotes | SAR_Eukaryotes | 89.8 | 1.62e-13 | NTclustered | gi|2055401904|ref|NC_056101.1| | 2794224 | g4004 | i0 | 86.585 | 33.4092827004219 | 82 | 10 | 35 | 1 | 3 | 84 | 4618 | 4698 | Euplotes vanleeuwenhoeki strain KKR18 mitochondrion, complete genome | blastn | 7918 | 89.8 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes vanleeuwenhoeki | ||
| 17569868 | 17569868 | PRJEB56699_P_NODE_6074_length_176_cov_2.095238_g5844_i0 | PRJEB56699 | 6074 | 176 | 2.095238 | 3.68761888 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 2.89e-74 | NTclustered | gi|114329811|ref|NC_008337.1| | 5901 | g5844 | i0 | 96.591 | 23.1534090909091 | 176 | 4 | 100 | 2 | 1 | 176 | 32957 | 33130 | Tetrahymena malaccensis mitochondrion, complete genome | blastn | 4075 | 291 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 21801341 | 21801341 | PRJEB56699_P_NODE_1058_length_568_cov_5.280148_g882_i0 | PRJEB56699 | 1058 | 568 | 5.280148 | 29.99124064 | Coleps hirtus | 60000 | SAR_Eukaryotes | SAR_Eukaryotes | 989 | 0 | NTclustered | gi|2026535536|gb|MW929305.1| | 60000 | g882 | i0 | 98.063 | 78.8045774647887 | 568 | 11 | 100 | 0 | 1 | 568 | 2775 | 2208 | Coleps hirtus strain AG Berninger/Pickham Uni Salzburg 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 | 44761 | 989 | 1 | Eukaryota | Sar | Ciliophora | Prostomatea | Prorodontida | Colepidae | Coleps | Coleps hirtus | ||
| 21801342 | 21801342 | PRJEB56699_P_NODE_2598_length_343_cov_2.041401_g2368_i0 | PRJEB56699 | 2598 | 343 | 2.041401 | 7.00200543 | Tetrahymena malaccensis | 5901 | SAR_Eukaryotes | SAR_Eukaryotes | 490 | 5.799999999999999e-134 | NTclustered | gi|114329811|ref|NC_008337.1| | 5901 | g2368 | i0 | 94.136 | 77.6239067055394 | 324 | 16 | 94 | 2 | 14 | 334 | 33301 | 33624 | Tetrahymena malaccensis mitochondrion, complete genome | blastn | 26625 | 490 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 23944345 | 23944345 | PRJEB56699_P_NODE_4479_length_226_cov_2.558376_g4249_i0 | PRJEB56699 | 4479 | 226 | 2.558376 | 5.78192976 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 8.84e-41 | NTclustered | gi|1268580094|gb|KY218574.1| | 5898 | g4249 | i0 | 100 | 51.2389380530973 | 97 | 0 | 75 | 0 | 1 | 97 | 444 | 540 | Tetrahymena furgasoni isolate 20749-1 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 11580 | 180 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena furgasoni |
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);;