contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA946307" and tax_phylum = "Cryptomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 925984 | 925984 | PRJNA946307_P_NODE_12961_length_364_cov_3.333333_g12095_i0 | PRJNA946307 | 12961 | 364 | 3.333333 | 12.13333212 | Rozella sp. | 1932610 | Fungi | Fungi | 141 | 7.17e-29 | NTclustered | gi|2468791001|gb|OQ702917.1| | 1932610 | g12095 | i0 | 92 | 27.7335164835165 | 100 | 8 | 27 | 0 | 126 | 225 | 3402 | 3501 | Rozella sp. isolate PSC230 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 10095 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella sp. | ||||
| 2202742 | 2202742 | PRJNA946307_P_NODE_52442_length_210_cov_3.118012_g51568_i0 | PRJNA946307 | 52442 | 210 | 3.118012 | 6.5478252 | Cryptomycota sp. | 2012228 | Fungi | Fungi | 139 | 1.38e-28 | NTclustered | gi|2468791071|gb|OQ702935.1| | 2012228 | g51568 | i0 | 96.429 | 38.7571428571429 | 84 | 3 | 40 | 0 | 111 | 194 | 3495 | 3412 | Cryptomycota sp. isolate PSC281 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 8139 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Cryptomycota sp. | |||||
| 3477647 | 3477647 | PRJNA946307_P_NODE_23563_length_264_cov_4.720930_g22689_i0 | PRJNA946307 | 23563 | 264 | 4.72093 | 12.4632552 | Cryptomycota sp. | 2012228 | Fungi | Fungi | 311 | 3.6e-80 | NTclustered | gi|2468790980|gb|OQ702912.1| | 2012228 | g22689 | i0 | 89.2 | 44.1666666666667 | 250 | 18 | 94 | 2 | 1 | 248 | 4126 | 3884 | Cryptomycota sp. isolate PSC211 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 11660 | 311 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Cryptomycota sp. | |||||
| 11129421 | 11129421 | PRJNA946307_P_NODE_114689_length_177_cov_3.414062_g113815_i0 | PRJNA946307 | 114689 | 177 | 3.414062 | 6.04288974 | Cryptomycota sp. | 2012228 | Fungi | Fungi | 145 | 2.4e-30 | NTclustered | gi|2468791035|gb|OQ702926.1| | 2012228 | g113815 | i0 | 94.681 | 51.5875706214689 | 94 | 4 | 53 | 1 | 3 | 95 | 3450 | 3543 | Cryptomycota sp. isolate PSC258 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 9131 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Cryptomycota sp. |
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);;