contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA278119" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4198133 | 4198133 | PRJNA278119_P_NODE_12224_length_326_cov_5.469314_g11976_i0 | PRJNA278119 | 12224 | 326 | 5.469314 | 17.82996364 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 121 | 8.28e-23 | NTclustered | gi|2432138713|ref|XM_053107478.1| | 110093 | g11976 | i0 | 84.252 | 6.58588957055215 | 127 | 16 | 38 | 3 | 188 | 312 | 148 | 24 | Polychytrium aggregatum large subunit ribosomal protein 29 (BJ171DRAFT_421272), partial mRNA | blastn | 2147 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 5474991 | 5474991 | PRJNA278119_P_NODE_9425_length_382_cov_2.075075_g9178_i0 | PRJNA278119 | 9425 | 382 | 2.075075 | 7.9267865 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 213 | 1.58e-50 | NTclustered | gi|2432142886|ref|XM_053110559.1| | 110093 | g9178 | i0 | 79.299 | 54.1701570680628 | 314 | 57 | 81 | 4 | 1 | 308 | 35 | 346 | Polychytrium aggregatum 60S ribosomal protein L42 (BJ171DRAFT_500193), mRNA | blastn | 20693 | 213 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 9299295 | 9299295 | PRJNA278119_P_NODE_24068_length_201_cov_1.940789_g23819_i0 | PRJNA278119 | 24068 | 201 | 1.940789 | 3.90098589 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 128 | 2.82e-25 | NTclustered | gi|2432157378|ref|XM_053107751.1| | 110093 | g23819 | i0 | 88.073 | 2.14925373134328 | 109 | 11 | 54 | 2 | 82 | 189 | 294 | 187 | Polychytrium aggregatum ribosomal protein L6, alpha-beta domain-containing protein (BJ171DRAFT_426015), partial mRNA | blastn | 432 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 11849882 | 11849882 | PRJNA278119_P_NODE_28490_length_185_cov_1.742647_g28241_i0 | PRJNA278119 | 28490 | 185 | 1.742647 | 3.22389695 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 99 | 2e-16 | NTclustered | gi|2432078701|ref|XM_053072586.1| | 1396493 | g28241 | i0 | 81.452 | 0.67027027027027 | 124 | 19 | 66 | 3 | 30 | 151 | 536 | 415 | Fimicolochytrium jonesii ribosomal protein L6, alpha-beta domain-containing protein (EV422DRAFT_567871), partial mRNA | blastn | 124 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 14400285 | 14400285 | PRJNA278119_P_NODE_31292_length_177_cov_1.617188_g31043_i0 | PRJNA278119 | 31292 | 177 | 1.617188 | 2.86242276 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 86.1 | 1.47e-12 | NTclustered | gi|2432162630|ref|XM_053112000.1| | 110093 | g31043 | i0 | 76.301 | 9.64406779661017 | 173 | 33 | 95 | 7 | 7 | 175 | 128 | 296 | Polychytrium aggregatum ribosomal protein L22/L17 (BJ171DRAFT_515986), mRNA | blastn | 1707 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 15674242 | 15674242 | PRJNA278119_P_NODE_5153_length_526_cov_2.572327_g4909_i0 | PRJNA278119 | 5153 | 526 | 2.572327 | 13.53044002 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 174 | 1.06e-38 | NTclustered | gi|2432142218|ref|XM_053114797.1| | 110093 | g4909 | i0 | 80 | 39.6673003802281 | 245 | 42 | 46 | 5 | 228 | 470 | 262 | 501 | Polychytrium aggregatum ribosomal protein S13/S18-domain-containing protein (BJ171DRAFT_597985), partial mRNA | blastn | 20865 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 15674247 | 15674247 | PRJNA278119_P_NODE_5333_length_516_cov_1.995717_g5088_i0 | PRJNA278119 | 5333 | 516 | 1.995717 | 10.29789972 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 195 | 7.94e-45 | NTclustered | gi|2432162630|ref|XM_053112000.1| | 110093 | g5088 | i0 | 76.238 | 26.9825581395349 | 404 | 74 | 77 | 16 | 46 | 441 | 523 | 134 | Polychytrium aggregatum ribosomal protein L22/L17 (BJ171DRAFT_515986), mRNA | blastn | 13923 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 19497495 | 19497495 | PRJNA278119_P_NODE_6536_length_466_cov_3.093525_g6290_i0 | PRJNA278119 | 6536 | 466 | 3.093525 | 14.4158265 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 128 | 7.3099999999999995e-25 | NTclustered | gi|2432097581|ref|XM_053071233.1| | 1396493 | g6290 | i0 | 82.313 | 4.18454935622318 | 147 | 26 | 32 | 0 | 20 | 166 | 83 | 229 | Fimicolochytrium jonesii 30S ribosomal protein S30e (EV422DRAFT_541825), mRNA | blastn | 1950 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii |
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);;