contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA577580" and tax_phylum = "Chytridiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3689529 | 3689529 | PRJNA577580_P_NODE_8543_length_310_cov_2.455696_g8465_i0 | PRJNA577580 | 8543 | 310 | 2.455696 | 7.6126576 | Eukaryota | 2759 | Fungi | Fungi | 176 | 1.65e-39 | NTclustered | gi|387156428|emb|HE806161.1| | 1229259 | g8465 | i0 | 86.335 | 48.9903225806452 | 161 | 22 | 52 | 0 | 112 | 272 | 1969 | 1809 | Uncultured Chytridium partial 26S rRNA gene, clone EopYyyy3 | blastn | 15187 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | uncultured Chytridium | ||
| 5667696 | 5667696 | PRJNA577580_P_NODE_10485_length_283_cov_2.538095_g10407_i0 | PRJNA577580 | 10485 | 283 | 2.538095 | 7.18280885 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 226 | 1.4499999999999998e-54 | NTclustered | gi|2432129754|ref|XM_053108222.1| | 110093 | g10407 | i0 | 84.348 | 33.1095406360424 | 230 | 36 | 81 | 0 | 16 | 245 | 1022 | 1251 | Polychytrium aggregatum DEAD box ATP-dependent RNA helicase (BJ171DRAFT_453702), mRNA | blastn | 9370 | 226 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 7515986 | 7515986 | PRJNA577580_P_NODE_586_length_1096_cov_23.459433_g543_i0 | PRJNA577580 | 586 | 1096 | 23.459433 | 257.11538568 | Neocallimastigaceae | 29007 | Fungi | Fungi | 300 | 3.61e-76 | NTclustered | gi|82398579|gb|DQ273829.1| | 324620 | g543 | i0 | 77.209 | 48.2436131386861 | 645 | 64 | 84 | 24 | 1 | 640 | 1408 | 1974 | Cyllamyces aberensis isolate AFTOL-ID 846 28S ribosomal RNA gene, partial sequence | blastn | 52875 | 302 | 0.993377483443709 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Cyllamyces | Cyllamyces aberensis | |
| 12043147 | 12043147 | PRJNA577580_P_NODE_5050_length_399_cov_1.447853_g4972_i0 | PRJNA577580 | 5050 | 399 | 1.447853 | 5.77693347 | Batrachochytrium dendrobatidis | 109871 | Fungi | Fungi | 80.5 | 1.75e-10 | NTclustered | gi|2897841418|gb|CP161937.1| | 109871 | g4972 | i0 | 95.918 | 13.3659147869674 | 49 | 2 | 12 | 0 | 3 | 51 | 40379 | 40331 | Batrachochytrium dendrobatidis strain JEL423 chromosome 15 | blastn | 5333 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 12617167 | 12617167 | PRJNA577580_P_NODE_5630_length_377_cov_2.825658_g5552_i0 | PRJNA577580 | 5630 | 377 | 2.825658 | 10.65273066 | Opisthokonta | 33154 | Fungi | Fungi | 195 | 5.639999999999999e-45 | NTclustered | gi|82398309|gb|DQ273787.1| | 64517 | g5552 | i0 | 94.488 | 37.132625994695 | 127 | 6 | 34 | 1 | 246 | 372 | 2154 | 2279 | Rhizophlyctis rosea isolate AFTOL-ID 43 28S ribosomal RNA gene, partial sequence | blastn | 13999 | 196 | 0.994897959183674 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 15866684 | 15866684 | PRJNA577580_P_NODE_16293_length_242_cov_1.668639_g16215_i0 | PRJNA577580 | 16293 | 242 | 1.668639 | 4.03810638 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 222 | 1.57e-53 | NTclustered | gi|2432168590|ref|XM_053112370.1| | 110093 | g16215 | i0 | 86.408 | 82.2396694214876 | 206 | 24 | 84 | 4 | 37 | 240 | 2246 | 2043 | Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_519711), mRNA | blastn | 19902 | 222 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 18415958 | 18415958 | PRJNA577580_P_NODE_4015_length_449_cov_5.851064_g3937_i0 | PRJNA577580 | 4015 | 449 | 5.851064 | 26.27127736 | Lacustromyces hiemalis | 110070 | Fungi | Fungi | 254 | 1.11e-62 | NTclustered | gi|1866582727|gb|MT730902.1| | 110070 | g3937 | i0 | 85.141 | 41.6837416481069 | 249 | 36 | 55 | 1 | 28 | 276 | 4563 | 4810 | Lacustromyces hiemalis isolate JEL0938 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 | 18716 | 254 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Lacustromyces | Lacustromyces hiemalis | ||
| 18989504 | 18989504 | PRJNA577580_P_NODE_935_length_908_cov_4.528144_g872_i0 | PRJNA577580 | 935 | 908 | 4.528144 | 41.11554752 | Eukaryota | 2759 | Fungi | Fungi | 368 | 8.02e-97 | NTclustered | gi|387156428|emb|HE806161.1| | 1229259 | g872 | i0 | 78.352 | 39.4449339207048 | 619 | 98 | 68 | 23 | 74 | 686 | 1381 | 1969 | Uncultured Chytridium partial 26S rRNA gene, clone EopYyyy3 | blastn | 35816 | 368 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | uncultured Chytridium |
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);;