contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJEB73599" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2685233 | 2685233 | PRJEB73599_P_NODE_1783_length_555_cov_4.627376_g1547_i0 | PRJEB73599 | 1783 | 555 | 4.627376 | 25.6819368 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 534 | 4.4499999999999997e-147 | NTclustered | gi|459348792|gb|KC249997.1| | 28002 | g1547 | i0 | 84.63 | 21.5261261261261 | 540 | 79 | 97 | 4 | 1 | 538 | 1322 | 1859 | Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 11947 | 534 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 3961315 | 3961315 | PRJEB73599_P_NODE_8964_length_172_cov_1.566434_g8677_i0 | PRJEB73599 | 8964 | 172 | 1.566434 | 2.69426648 | Hexamita sp. | 28003 | Fornicata | other_Eukaryota | 246 | 6.17e-61 | NTclustered | gi|2547715591|gb|OR291218.1| | 28003 | g8677 | i0 | 92.486 | 19.1686046511628 | 173 | 11 | 100 | 2 | 1 | 172 | 453 | 282 | Hexamita sp. isolate AYEN small subunit ribosomal RNA gene, partial sequence | blastn | 3297 | 246 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita sp. | |||
| 15023409 | 15023409 | PRJEB73599_P_NODE_4032_length_343_cov_4.009554_g3745_i0 | PRJEB73599 | 4032 | 343 | 4.009554 | 13.75277022 | Trepomonas | 44997 | Fornicata | other_Eukaryota | 632 | 9.11e-177 | NTclustered | gi|2592099216|gb|OR670399.1| | 460177 | g3745 | i0 | 100 | 95.2069970845481 | 342 | 0 | 99 | 0 | 1 | 342 | 496 | 837 | Trepomonas sp. PPS6 isolate NO666 small subunit ribosomal RNA gene, partial sequence | blastn | 32656 | 632 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Trepomonas | Trepomonas sp. PPS6 | |||
| 15437687 | 15437687 | PRJEB73599_P_NODE_8093_length_190_cov_1.447205_g7806_i0 | PRJEB73599 | 8093 | 190 | 1.447205 | 2.7496895 | Trepomonas sp. PPS6 | 460177 | Fornicata | other_Eukaryota | 263 | 6.93e-66 | NTclustered | gi|2592099210|gb|OR670393.1| | 460177 | g7806 | i0 | 91.979 | 35.6315789473684 | 187 | 15 | 98 | 0 | 4 | 190 | 539 | 725 | Trepomonas sp. PPS6 isolate Schon small subunit ribosomal RNA gene, partial sequence | blastn | 6770 | 263 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Trepomonas | Trepomonas sp. PPS6 | |||
| 19260765 | 19260765 | PRJEB73599_P_NODE_3316_length_393_cov_5.760989_g3030_i0 | PRJEB73599 | 3316 | 393 | 5.760989 | 22.64068677 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 477 | 5.2299999999999986e-130 | NTclustered | gi|459348792|gb|KC249997.1| | 28002 | g3030 | i0 | 88.747 | 129.982188295165 | 391 | 42 | 99 | 2 | 4 | 393 | 209 | 598 | Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 51083 | 477 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 20122029 | 20122029 | PRJEB73599_P_NODE_5136_length_285_cov_4.613281_g4849_i0 | PRJEB73599 | 5136 | 285 | 4.613281 | 13.14785085 | Trepomonas | 44997 | Fornicata | other_Eukaryota | 516 | 7.77e-142 | NTclustered | gi|2592099221|gb|OR670404.1| | 460177 | g4849 | i0 | 99.298 | 87.6070175438597 | 285 | 2 | 100 | 0 | 1 | 285 | 314 | 30 | Trepomonas sp. PPS6 isolate 77MVwsc small subunit ribosomal RNA gene, partial sequence | blastn | 24968 | 516 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Trepomonas | Trepomonas sp. PPS6 | |||
| 20536103 | 20536103 | PRJEB73599_P_NODE_6697_length_228_cov_3.798995_g6410_i0 | PRJEB73599 | 6697 | 228 | 3.798995 | 8.6617086 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 248 | 2.4199999999999997e-61 | NTclustered | gi|459348792|gb|KC249997.1| | 28002 | g6410 | i0 | 93.902 | 0.719298245614035 | 164 | 10 | 72 | 0 | 65 | 228 | 2970 | 2807 | Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 164 | 248 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 23086984 | 23086984 | PRJEB73599_P_NODE_5479_length_271_cov_2.975207_g5192_i0 | PRJEB73599 | 5479 | 271 | 2.975207 | 8.06281097 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 316 | 7.98e-82 | NTclustered | gi|459348792|gb|KC249997.1| | 28002 | g5192 | i0 | 87.823 | 1.98892988929889 | 271 | 32 | 100 | 1 | 1 | 271 | 879 | 1148 | Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 539 | 316 | 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);;