contig_metadata
5 rows where bioproject = "PRJNA642647" and tax_clade = "Metamonada"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3710344 | 3710344 | PRJNA642647_P_NODE_2223_length_230_cov_2.015544_g2173_i0 | PRJNA642647 | 2223 | 230 | 2.015544 | 4.6357512 | Trepomonas | 44997 | Fornicata | other_Eukaryota | 416 | 6.319999999999998e-112 | NTclustered | gi|2592099211|gb|OR670394.1| | 460177 | g2173 | i0 | 100 | 97.6521739130435 | 225 | 0 | 98 | 0 | 4 | 228 | 678 | 902 | Trepomonas sp. PPS6 isolate ZMB2 small subunit ribosomal RNA gene, partial sequence | blastn | 22460 | 416 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Trepomonas | Trepomonas sp. PPS6 | |||
| 15920849 | 15920849 | PRJNA642647_P_NODE_3393_length_192_cov_1.470968_g3343_i0 | PRJNA642647 | 3393 | 192 | 1.470968 | 2.82425856 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 204 | 4.31e-48 | NTclustered | gi|459348792|gb|KC249997.1| | 28002 | g3343 | i0 | 86.316 | 1.41145833333333 | 190 | 23 | 98 | 3 | 1 | 189 | 850 | 663 | Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 271 | 204 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 17736458 | 17736458 | PRJNA642647_P_NODE_2534_length_217_cov_1.794444_g2484_i0 | PRJNA642647 | 2534 | 217 | 1.794444 | 3.89394348 | Trepomonas | 44997 | Fornicata | other_Eukaryota | 351 | 1.69e-92 | NTclustered | gi|156066402|gb|EF551174.1| | 460177 | g2484 | i0 | 96.262 | 62.1382488479263 | 214 | 8 | 99 | 0 | 4 | 217 | 68 | 281 | Trepomonas sp. PPS6 small subunit ribosomal RNA gene, partial sequence | blastn | 13484 | 351 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Trepomonas | Trepomonas sp. PPS6 | |||
| 24844293 | 24844293 | PRJNA642647_P_NODE_1540_length_280_cov_2.687243_g1490_i0 | PRJNA642647 | 1540 | 280 | 2.687243 | 7.5242804 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 279 | 1.09e-70 | NTclustered | gi|459348792|gb|KC249997.1| | 28002 | g1490 | i0 | 88.412 | 0.832142857142857 | 233 | 25 | 83 | 2 | 45 | 276 | 1910 | 1679 | Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 233 | 279 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 27017966 | 27017966 | PRJNA642647_P_NODE_3782_length_184_cov_1.408163_g3732_i0 | PRJNA642647 | 3782 | 184 | 1.408163 | 2.59101992 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 70.9 | 6.21e-13 | NR | CAK8748468.1 | 28002 | g3732 | i0 | 70.2 | 0.766304347826087 | 47 | 14 | 76.6 | 0 | 44 | 184 | 1 | 47 | CAK8748468.1 HINF_094878 [Hexamita inflata] | diamond | 141 | 70.9 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata |
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);;