contig_metadata
6 rows where bioproject = "PRJEB83711", tax_clade = "Opisthokonta" and tax_phylum = "Platyhelminthes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4826650 | 4826650 | PRJEB83711_P_NODE_35424_length_303_cov_8.682609_g35158_i0 | PRJEB83711 | 35424 | 303 | 8.682609 | 26.30830527 | Plagiorchiida | 27871 | Platyhelminthes | Platyhelminthes | 549 | 8.209999999999997e-152 | NTclustered | gi|1799639270|gb|MN970007.1| | 6192 | g35158 | i0 | 99.34 | 100.554455445545 | 303 | 2 | 100 | 0 | 1 | 303 | 5323 | 5021 | Fasciola hepatica isolate Geelong small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence; and non-transcribed intergenic spacer, partial sequence | blastn | 30468 | 549 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 10346958 | 10346958 | PRJEB83711_P_NODE_39769_length_289_cov_11.787037_g39503_i0 | PRJEB83711 | 39769 | 289 | 11.787037 | 34.06453693 | Isthmiophora hortensis | 292498 | Platyhelminthes | Platyhelminthes | 518 | 2.19e-142 | NTclustered | gi|52000522|dbj|AB189982.1| | 292498 | g39503 | i0 | 98.962 | 100.757785467128 | 289 | 3 | 100 | 0 | 1 | 289 | 6022 | 6310 | Isthmiophora hortensis genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence | blastn | 29119 | 518 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Isthmiophora | Isthmiophora hortensis | |
| 11201865 | 11201865 | PRJEB83711_P_NODE_37149_length_297_cov_2.272321_g36883_i0 | PRJEB83711 | 37149 | 297 | 2.272321 | 6.74879337 | Plagiorchiida | 27871 | Platyhelminthes | Platyhelminthes | 171 | 7.299999999999999e-38 | NTclustered | gi|1907754960|gb|MT862417.1| | 6192 | g36883 | i0 | 77.558 | 9.02693602693603 | 303 | 54 | 98 | 11 | 5 | 296 | 6504 | 6803 | Fasciola hepatica isolate DM402 mitochondrion, partial genome | blastn | 2681 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 13752226 | 13752226 | PRJEB83711_P_NODE_55931_length_255_cov_38.043956_g55665_i0 | PRJEB83711 | 55931 | 255 | 38.043956 | 97.0120878 | Fasciola | 6191 | Platyhelminthes | Platyhelminthes | 361 | 3.3899999999999996e-95 | NTclustered | gi|1799639270|gb|MN970007.1| | 6192 | g55665 | i0 | 92.829 | 37.0588235294118 | 251 | 15 | 97 | 3 | 1 | 248 | 6795 | 7045 | Fasciola hepatica isolate Geelong small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence; and non-transcribed intergenic spacer, partial sequence | blastn | 9450 | 361 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 22675783 | 22675783 | PRJEB83711_P_NODE_73598_length_244_cov_18.309942_g73332_i0 | PRJEB83711 | 73598 | 244 | 18.309942 | 44.67625848 | Petasiger | 235441 | Platyhelminthes | Platyhelminthes | 444 | 3.11e-120 | NTclustered | gi|1209055173|gb|KY284002.1| | 1607861 | g73332 | i0 | 99.588 | 99.594262295082 | 243 | 1 | 99 | 0 | 1 | 243 | 898 | 1140 | Petasiger sp. GC-2015 isolate PH1 28S ribosomal RNA gene, partial sequence | blastn | 24301 | 444 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Petasiger | Petasiger sp. GC-2015 | |
| 23096233 | 23096233 | PRJEB83711_P_NODE_49139_length_268_cov_9.194872_g48873_i0 | PRJEB83711 | 49139 | 268 | 9.194872 | 24.64225696 | Isthmiophora hortensis | 292498 | Platyhelminthes | Platyhelminthes | 466 | 7.39e-127 | NTclustered | gi|52000522|dbj|AB189982.1| | 292498 | g48873 | i0 | 98.134 | 101.373134328358 | 268 | 3 | 99 | 2 | 2 | 268 | 5754 | 5488 | Isthmiophora hortensis genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence | blastn | 27168 | 466 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Isthmiophora | Isthmiophora hortensis |
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);;