contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJEB28062" and tax_phylum = "Zoopagomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2575383 | 2575383 | PRJEB28062_P_NODE_78603_length_381_cov_21.535714_g76241_i0 | PRJEB28062 | 78603 | 381 | 21.535714 | 82.05107034 | Capillidium heterosporum | 1167838 | Fungi | Fungi | 370 | 8.83e-98 | NTclustered | gi|1583106424|ref|NC_040967.1| | 1167838 | g76241 | i0 | 86.607 | 4.04724409448819 | 336 | 44 | 88 | 1 | 22 | 356 | 10760 | 10425 | Conidiobolus heterosporus strain RCEF6331 mitochondrion, complete genome | blastn | 1542 | 370 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Capillidium | Capillidium heterosporum | |
| 6402737 | 6402737 | PRJEB28062_P_NODE_33686_length_632_cov_150.640429_g31374_i0 | PRJEB28062 | 33686 | 632 | 150.640429 | 952.04751128 | Entomophthora muscae | 34485 | Fungi | Fungi | 375 | 3.2799999999999995e-99 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g31374 | i0 | 84.675 | 39.9762658227848 | 385 | 49 | 79 | 10 | 223 | 603 | 2061 | 1683 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 25265 | 375 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 8952125 | 8952125 | PRJEB28062_P_NODE_59028_length_456_cov_27.114883_g56669_i0 | PRJEB28062 | 59028 | 456 | 27.114883 | 123.64386648 | Entomophaga aulicae | 39303 | Fungi | Fungi | 335 | 3.9199999999999984e-87 | NTclustered | gi|1373048|gb|U35394.1|EAU35394 | 39303 | g56669 | i0 | 82.707 | 51.015350877193 | 399 | 48 | 85 | 16 | 59 | 446 | 4745 | 5133 | Entomophaga aulicae 18S, ITS-1, 5.8S, ITS-2, and 25S ribosomal RNA genes | blastn | 23263 | 335 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophaga | Entomophaga aulicae | |
| 21702592 | 21702592 | PRJEB28062_P_NODE_96898_length_324_cov_4.099602_g94536_i0 | PRJEB28062 | 96898 | 324 | 4.099602 | 13.28271048 | Entomophthora muscae | 34485 | Fungi | Fungi | 459 | 1.5299999999999999e-124 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g94536 | i0 | 95.189 | 55.8858024691358 | 291 | 13 | 90 | 1 | 11 | 301 | 2281 | 1992 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 18107 | 459 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae |
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);;