contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_phylum = "Parabasalia"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2849875 | 2849875 | PRJNA1148190_P_NODE_687683_length_246_cov_0.890173_g676510_i0 | PRJNA1148190 | 687683 | 246 | 0.890173 | 2.18982558 | Trichomonas vaginalis | 5722 | Parabasalia | other_Eukaryota | 58.4 | 4.78e-4 | NTclustered | gi|123458278|ref|XM_001316525.1| | 412133 | g676510 | i0 | 97.059 | 0.138211382113821 | 34 | 1 | 14 | 0 | 185 | 218 | 4797 | 4830 | Trichomonas vaginalis G3 uncharacterized protein (TVAGG3_0220710), partial mRNA | blastn | 34 | 58.4 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 5399105 | 5399105 | PRJNA1148190_P_NODE_45825_length_909_cov_1.416268_g35168_i0 | PRJNA1148190 | 45825 | 909 | 1.416268 | 12.87387612 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 56.5 | 0.007 | NTclustered | gi|2806481794|ref|XM_068511670.1| | 1144522 | g35168 | i0 | 97.059 | 0.0374037403740374 | 34 | 0 | 4 | 1 | 442 | 475 | 7799 | 7831 | Tritrichomonas foetus uncharacterized protein (TRFO_37840), partial mRNA | blastn | 34 | 56.5 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 6670256 | 6670256 | PRJNA1148190_P_NODE_217026_length_364_cov_0.869416_g205856_i0 | PRJNA1148190 | 217026 | 364 | 0.869416 | 3.16467424 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 52.8 | 0.035 | NTclustered | gi|2806457310|ref|XM_068503063.1| | 1144522 | g205856 | i0 | 100 | 0.0769230769230769 | 28 | 0 | 8 | 0 | 53 | 80 | 2533 | 2506 | Tritrichomonas foetus uncharacterized protein (TRFO_23290), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 10498544 | 10498544 | PRJNA1148190_P_NODE_382129_length_290_cov_1.133641_g370956_i0 | PRJNA1148190 | 382129 | 290 | 1.133641 | 3.2875589 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2806451296|ref|XM_068489875.1| | 1144522 | g370956 | i0 | 89.13 | 0.158620689655172 | 46 | 4 | 16 | 1 | 140 | 185 | 1320 | 1276 | Tritrichomonas foetus uncharacterized protein (TRFO_01045), partial mRNA | blastn | 46 | 56.5 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 15602635 | 15602635 | PRJNA1148190_P_NODE_757213_length_242_cov_1.118343_g746040_i0 | PRJNA1148190 | 757213 | 242 | 1.118343 | 2.70639006 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2806461390|ref|XM_068504595.1| | 1144522 | g746040 | i0 | 96.875 | 0.132231404958678 | 32 | 1 | 13 | 0 | 139 | 170 | 3162 | 3131 | Tritrichomonas foetus uncharacterized protein (TRFO_25833), partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 16876920 | 16876920 | PRJNA1148190_P_NODE_762594_length_242_cov_0.911243_g751421_i0 | PRJNA1148190 | 762594 | 242 | 0.911243 | 2.20520806 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2806472845|ref|XM_068508721.1| | 1144522 | g751421 | i0 | 96.875 | 0.132231404958678 | 32 | 0 | 13 | 1 | 24 | 55 | 1934 | 1904 | Tritrichomonas foetus uncharacterized protein (TRFO_32844), partial mRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 23245501 | 23245501 | PRJNA1148190_P_NODE_269159_length_334_cov_0.896552_g257988_i0 | PRJNA1148190 | 269159 | 334 | 0.896552 | 2.99448368 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 65.8 | 4.04e-6 | NTclustered | gi|2806479491|ref|XM_068510990.1| | 1144522 | g257988 | i0 | 91.489 | 0.224550898203593 | 47 | 4 | 14 | 0 | 70 | 116 | 448 | 402 | Tritrichomonas foetus CAMK family protein kinase (TRFO_36707), partial mRNA | blastn | 75 | 65.8 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus |
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);;