contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_phylum = "Fornicata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1639537 | 1639537 | PRJNA168635_P_NODE_6782_length_325_cov_5.782609_g6371_i0 | PRJNA168635 | 6782 | 325 | 5.782609 | 18.79347925 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 381 | 3.429999999999999e-101 | NTclustered | gi|459348792|gb|KC249997.1| | 28002 | g6371 | i0 | 87.879 | 25.7015384615385 | 330 | 32 | 100 | 6 | 1 | 325 | 1096 | 1422 | Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 8353 | 381 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 6742462 | 6742462 | PRJNA168635_P_NODE_8546_length_288_cov_4.054393_g8131_i0 | PRJNA168635 | 8546 | 288 | 4.054393 | 11.67665184 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 350 | 8.44e-92 | NTclustered | gi|459348792|gb|KC249997.1| | 28002 | g8131 | i0 | 88.699 | 55.9409722222222 | 292 | 25 | 100 | 8 | 1 | 288 | 2963 | 2676 | Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 16111 | 350 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 12532784 | 12532784 | PRJNA168635_P_NODE_14270_length_213_cov_6.902439_g13854_i0 | PRJNA168635 | 14270 | 213 | 6.902439 | 14.70219507 | Trepomonas | 44997 | Fornicata | other_Eukaryota | 394 | 2.7e-105 | NTclustered | gi|2592099176|gb|OR670372.1| | 460177 | g13854 | i0 | 100 | 60.2723004694836 | 213 | 0 | 100 | 0 | 1 | 213 | 651 | 439 | Trepomonas sp. PPS6 isolate Bot small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 12838 | 394 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Trepomonas | Trepomonas sp. PPS6 | |||
| 13118512 | 13118512 | PRJNA168635_P_NODE_5691_length_354_cov_6.888525_g5286_i0 | PRJNA168635 | 5691 | 354 | 6.888525 | 24.3853785 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 375 | 1.7499999999999995e-99 | NTclustered | gi|459348792|gb|KC249997.1| | 28002 | g5286 | i0 | 85.876 | 6.75706214689266 | 354 | 48 | 99 | 2 | 2 | 354 | 281 | 633 | Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 2392 | 375 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 15081735 | 15081735 | PRJNA168635_P_NODE_13432_length_221_cov_2.889535_g13016_i0 | PRJNA168635 | 13432 | 221 | 2.889535 | 6.38587235 | Trepomonas | 44997 | Fornicata | other_Eukaryota | 272 | 1.38e-68 | NTclustered | gi|2592099176|gb|OR670372.1| | 460177 | g13016 | i0 | 89.14 | 91.5203619909502 | 221 | 21 | 100 | 2 | 1 | 221 | 823 | 606 | Trepomonas sp. PPS6 isolate Bot small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 20226 | 272 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Trepomonas | Trepomonas sp. PPS6 | |||
| 15081913 | 15081913 | PRJNA168635_P_NODE_5592_length_357_cov_5.298701_g5187_i0 | PRJNA168635 | 5592 | 357 | 5.298701 | 18.91636257 | Trepomonas | 44997 | Fornicata | other_Eukaryota | 636 | 7.339999999999998e-178 | NTclustered | gi|2592099177|gb|OR670373.1| | 460177 | g5187 | i0 | 100 | 86.1708683473389 | 344 | 0 | 96 | 0 | 9 | 352 | 398 | 55 | Trepomonas sp. PPS6 isolate MACHUPICCHU small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 30763 | 636 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Trepomonas | Trepomonas sp. PPS6 | |||
| 20766257 | 20766257 | PRJNA168635_P_NODE_5137_length_373_cov_4.756173_g4733_i0 | PRJNA168635 | 5137 | 373 | 4.756173 | 17.74052529 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 407 | 6.57e-109 | NTclustered | gi|459348792|gb|KC249997.1| | 28002 | g4733 | i0 | 89.297 | 2.77479892761394 | 327 | 32 | 87 | 3 | 1 | 326 | 698 | 1022 | Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 1035 | 407 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 21455950 | 21455950 | PRJNA168635_P_NODE_13717_length_218_cov_6.544379_g13301_i0 | PRJNA168635 | 13717 | 218 | 6.544379 | 14.26674622 | Trepomonas | 44997 | Fornicata | other_Eukaryota | 403 | 4.62e-108 | NTclustered | gi|2592099221|gb|OR670404.1| | 460177 | g13301 | i0 | 100 | 98.2844036697248 | 218 | 0 | 100 | 0 | 1 | 218 | 1025 | 1242 | Trepomonas sp. PPS6 isolate 77MVwsc small subunit ribosomal RNA gene, partial sequence | blastn | 21426 | 403 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Trepomonas | Trepomonas sp. PPS6 |
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);;