contig_metadata
11 rows where bioproject = "PRJEB12366", tax_clade = "Sar" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 985670 | 985670 | PRJEB12366_S_NODE_461_length_246_cov_6.317536_g453_i0 | PRJEB12366 | 461 | 246 | 6.317536 | 15.54113856 | Paracercomonas | 372085 | SAR_Eukaryotes | SAR_Eukaryotes | 442 | 1.1299999999999995e-119 | NTclustered | gi|262262832|gb|FJ790725.1| | 466266 | g453 | i0 | 99.587 | 98.4186991869919 | 242 | 1 | 98 | 0 | 5 | 246 | 755 | 996 | Paracercomonas crassicauda strain ATCC 50316 18S ribosomal RNA gene, partial sequence | blastn | 24211 | 442 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas crassicauda | |||
| 1295002 | 1295002 | PRJEB12366_P_NODE_5042_length_370_cov_4.119403_g4852_i0 | PRJEB12366 | 5042 | 370 | 4.119403 | 15.2417911 | Lotharella vacuolata | 74820 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 1.93e-64 | NTclustered | gi|290760484|gb|GQ144687.1| | 74820 | g4852 | i0 | 87.281 | 87.8378378378378 | 228 | 27 | 61 | 2 | 1 | 227 | 2796 | 2570 | Lotharella vacuolata large subunit ribosomal RNA gene, partial sequence | blastn | 32500 | 259 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Lotharella | Lotharella vacuolata | ||||
| 3847025 | 3847025 | PRJEB12366_S_NODE_1444_length_199_cov_2.957317_g1436_i0 | PRJEB12366 | 1444 | 199 | 2.957317 | 5.88506083 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 89.8 | 1.32e-13 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g1436 | i0 | 98.039 | 0.256281407035176 | 51 | 1 | 26 | 0 | 72 | 122 | 1518 | 1568 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 51 | 89.8 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 3847027 | 3847027 | PRJEB12366_S_NODE_164_length_342_cov_61.667752_g156_i0 | PRJEB12366 | 164 | 342 | 61.667752 | 210.90371184 | Paracercomonas crassicauda | 466266 | SAR_Eukaryotes | SAR_Eukaryotes | 632 | 9.079999999999999e-177 | NTclustered | gi|262262832|gb|FJ790725.1| | 466266 | g156 | i0 | 100 | 98.7485380116959 | 342 | 0 | 100 | 0 | 1 | 342 | 42 | 383 | Paracercomonas crassicauda strain ATCC 50316 18S ribosomal RNA gene, partial sequence | blastn | 33772 | 632 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas crassicauda | |||
| 5123206 | 5123206 | PRJEB12366_S_NODE_2065_length_180_cov_1.496552_g2057_i0 | PRJEB12366 | 2065 | 180 | 1.496552 | 2.6937936 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 2.41e-40 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g2057 | i0 | 85.714 | 0.933333333333333 | 168 | 24 | 93 | 0 | 10 | 177 | 1706 | 1873 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 168 | 178 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 9913804 | 9913804 | PRJEB12366_P_NODE_13648_length_195_cov_1.650000_g13458_i0 | PRJEB12366 | 13648 | 195 | 1.65 | 3.2175 | Sandona | 1239209 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 1.15e-93 | NTclustered | gi|219524776|gb|EU709139.1| | 175275 | g13458 | i0 | 99.487 | 100 | 195 | 1 | 100 | 0 | 1 | 195 | 779 | 973 | Uncultured cercozoan isolate AH44p81t12 18S ribosomal RNA gene, partial sequence | blastn | 19500 | 355 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 12774430 | 12774430 | PRJEB12366_S_NODE_351_length_265_cov_34.791304_g343_i0 | PRJEB12366 | 351 | 265 | 34.791304 | 92.1969556 | Cercomonas sp. | 1979794 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 3.91e-25 | NTclustered | gi|2651357794|gb|PP174308.1| | 1979794 | g343 | i0 | 82.278 | 68.9169811320755 | 158 | 19 | 59 | 7 | 63 | 219 | 3830 | 3681 | Cercomonas sp. isolate JGP5 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 | 18263 | 128 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. | |||
| 14048860 | 14048860 | PRJEB12366_P_NODE_14632_length_187_cov_1.381579_g14442_i0 | PRJEB12366 | 14632 | 187 | 1.381579 | 2.58355273 | Sandona mutans | 563755 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 6.56e-91 | NTclustered | gi|224996445|gb|FJ654277.1| | 563755 | g14442 | i0 | 100 | 99.9786096256685 | 187 | 0 | 100 | 0 | 1 | 187 | 624 | 438 | Cercozoa sp. ATCC50314p145at3 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 18696 | 346 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Sandonidae | Sandona | Sandona mutans | |||
| 14048932 | 14048932 | PRJEB12366_S_NODE_692_length_227_cov_6.838542_g684_i0 | PRJEB12366 | 692 | 227 | 6.838542 | 15.52349034 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 8.699999999999997e-56 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g684 | i0 | 87.94 | 47.6563876651982 | 199 | 19 | 87 | 5 | 31 | 227 | 472 | 277 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 10818 | 230 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 16597614 | 16597614 | PRJEB12366_S_NODE_2434_length_173_cov_2.623188_g2426_i0 | PRJEB12366 | 2434 | 173 | 2.623188 | 4.53811524 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 7.98e-65 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g2426 | i0 | 93.678 | 2.36994219653179 | 174 | 10 | 100 | 1 | 1 | 173 | 2709 | 2536 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 410 | 259 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 22972796 | 22972796 | PRJEB12366_S_NODE_2099_length_179_cov_8.291667_g2091_i0 | PRJEB12366 | 2099 | 179 | 8.291667 | 14.84208393 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 298 | 1.76e-76 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g2091 | i0 | 99.39 | 92.463687150838 | 164 | 1 | 92 | 0 | 16 | 179 | 1372 | 1535 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 16551 | 298 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina |
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);;