contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1115053" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1503229 | 1503229 | PRJNA1115053_S_NODE_39602_length_365_cov_2.229814_g37785_i0 | PRJNA1115053 | 39602 | 365 | 2.229814 | 8.1388211 | Spironucleus vortens | 58336 | Fornicata | other_Eukaryota | 217 | 1.16e-51 | NTclustered | gi|5566180|gb|AF159517.1|AF159517 | 58336 | g37785 | i0 | 77.809 | 45.9205479452055 | 356 | 75 | 97 | 3 | 1 | 354 | 704 | 1057 | Spironucleus vortens enolase gene, partial cds | blastn | 16761 | 217 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus vortens | |||
| 1503807 | 1503807 | PRJNA1115053_S_NODE_62782_length_309_cov_19.063910_g60965_i0 | PRJNA1115053 | 62782 | 309 | 19.06391 | 58.9074819 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 86.1 | 2.84e-12 | NTclustered | gi|459348792|gb|KC249997.1| | 28002 | g60965 | i0 | 84.884 | 13.1909385113269 | 86 | 11 | 27 | 2 | 226 | 309 | 2853 | 2768 | Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 4076 | 86.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 2775004 | 2775004 | PRJNA1115053_S_NODE_181823_length_202_cov_1.509434_g180006_i0 | PRJNA1115053 | 181823 | 202 | 1.509434 | 3.04905668 | Giardia duodenalis | 5741 | Fornicata | other_Eukaryota | 159 | 1.01e-34 | NTclustered | gi|1595200664|gb|MK043783.1| | 5741 | g180006 | i0 | 82.955 | 1.91089108910891 | 176 | 30 | 87 | 0 | 3 | 178 | 690 | 515 | Giardia intestinalis isolate P458 thioredoxin peroxidase (prx1) gene, complete cds | blastn | 386 | 159 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 5325477 | 5325477 | PRJNA1115053_S_NODE_10685_length_576_cov_5.459662_g9043_i0 | PRJNA1115053 | 10685 | 576 | 5.459662 | 31.44765312 | Spironucleus muris | 39710 | Fornicata | other_Eukaryota | 928 | 0 | NTclustered | gi|157932098|gb|EU043230.1| | 39710 | g9043 | i0 | 98.853 | 83.4947916666667 | 523 | 1 | 90 | 5 | 58 | 576 | 1353 | 832 | Spironucleus muris small subunit ribosomal RNA gene, partial sequence | blastn | 48093 | 928 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus muris | |||
| 9156328 | 9156328 | PRJNA1115053_S_NODE_4348_length_811_cov_7.537760_g3274_i0 | PRJNA1115053 | 4348 | 811 | 7.53776 | 61.1312336 | Spironucleus muris | 39710 | Fornicata | other_Eukaryota | 1382 | 0 | NTclustered | gi|157932098|gb|EU043230.1| | 39710 | g3274 | i0 | 99.604 | 43.5635018495684 | 758 | 1 | 93 | 2 | 1 | 757 | 757 | 1 | Spironucleus muris small subunit ribosomal RNA gene, partial sequence | blastn | 35330 | 1382 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus muris | |||
| 11703858 | 11703858 | PRJNA1115053_S_NODE_214810_length_188_cov_1.200000_g212993_i0 | PRJNA1115053 | 214810 | 188 | 1.2 | 2.256 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 215 | 1.94e-51 | NTclustered | gi|2794870705|ref|XM_067904278.1| | 348837 | g212993 | i0 | 87.302 | 6.07446808510638 | 189 | 22 | 100 | 2 | 1 | 188 | 359 | 172 | Spironucleus salmonicida histone H3 (SS50377_20335), partial mRNA | blastn | 1142 | 215 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 11707137 | 11707137 | PRJNA1115053_S_NODE_3890_length_847_cov_15.299751_g2890_i0 | PRJNA1115053 | 3890 | 847 | 15.299751 | 129.58889097 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 152 | 8.17e-32 | NTclustered | gi|9378|emb|X65063.1| | 5742 | g2890 | i0 | 82.659 | 1.98110979929162 | 173 | 28 | 20 | 2 | 153 | 324 | 5286 | 5115 | G.muris ribosomal RNA operon DNA encoding 16S, 23S and 5.8S ribosomal RNA | blastn | 1678 | 152 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 14253514 | 14253514 | PRJNA1115053_S_NODE_188572_length_199_cov_1.230769_g186755_i0 | PRJNA1115053 | 188572 | 199 | 1.230769 | 2.44923031 | Spironucleus muris | 39710 | Fornicata | other_Eukaryota | 363 | 7.019999999999998e-96 | NTclustered | gi|2522339|gb|U94405.1|SMU94405 | 39710 | g186755 | i0 | 99.497 | 4.07035175879397 | 199 | 1 | 100 | 0 | 1 | 199 | 509 | 311 | Spironucleus muris elongation factor 1 alpha gene, partial cds | blastn | 810 | 363 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus muris | |||
| 15526560 | 15526560 | PRJNA1115053_S_NODE_16753_length_488_cov_12.505618_g14970_i0 | PRJNA1115053 | 16753 | 488 | 12.505618 | 61.02741584 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 200 | 1.61e-46 | NTclustered | gi|459348792|gb|KC249997.1| | 28002 | g14970 | i0 | 90.26 | 7.44877049180328 | 154 | 13 | 75 | 2 | 1 | 152 | 2129 | 2282 | Hexamita inflata 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 3635 | 200 | 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);;