contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA611476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 589601 | 589601 | PRJNA611476_P_NODE_49661_length_309_cov_0.978814_g48870_i0 | PRJNA611476 | 49661 | 309 | 0.978814 | 3.02453526 | Rhizophydiales sp. | 2011922 | Fungi | Fungi | 52.8 | 0.029 | NTclustered | gi|2468790959|gb|OQ702906.1| | 2011922 | g48870 | i0 | 100 | 0.0906148867313916 | 28 | 0 | 9 | 0 | 181 | 208 | 4191 | 4164 | Rhizophydiales sp. isolate PSC196 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 | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Rhizophydiales sp. | |||
| 589636 | 589636 | PRJNA611476_P_NODE_51921_length_303_cov_1.004348_g51130_i0 | PRJNA611476 | 51921 | 303 | 1.004348 | 3.04317444 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 226 | 1.5699999999999995e-54 | NTclustered | gi|2432157894|ref|XM_053108463.1| | 110093 | g51130 | i0 | 80.399 | 38.2343234323432 | 301 | 55 | 99 | 4 | 1 | 299 | 464 | 166 | Polychytrium aggregatum ribosomal protein L4 domain-containing protein (BJ171DRAFT_461012), mRNA | blastn | 11585 | 226 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 6967763 | 6967763 | PRJNA611476_P_NODE_36866_length_347_cov_2.131387_g36075_i0 | PRJNA611476 | 36866 | 347 | 2.131387 | 7.39591289 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 211 | 5.12e-50 | NTclustered | gi|2432132283|ref|XM_053107992.1| | 110093 | g36075 | i0 | 80.142 | 33.6167146974063 | 282 | 56 | 81 | 0 | 57 | 338 | 168 | 449 | Polychytrium aggregatum 13 kDa ribonucleoprotein-associated protein (BJ171DRAFT_438086), mRNA | blastn | 11665 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 7525420 | 7525420 | PRJNA611476_P_NODE_12326_length_557_cov_6.020661_g11539_i0 | PRJNA611476 | 12326 | 557 | 6.020661 | 33.53508177 | Fungi | 4751 | Fungi | Fungi | 206 | 3.98e-48 | NTclustered | gi|2432143272|ref|XM_053110602.1| | 110093 | g11539 | i0 | 87.931 | 28.4955116696589 | 174 | 21 | 31 | 0 | 280 | 453 | 350 | 177 | Polychytrium aggregatum 40S ribosomal protein S28 (BJ171DRAFT_500751), mRNA | blastn | 15872 | 206 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 7525717 | 7525717 | PRJNA611476_P_NODE_43006_length_327_cov_3.724409_g42215_i0 | PRJNA611476 | 43006 | 327 | 3.724409 | 12.17881743 | Gallinipes | 2304323 | Fungi | Fungi | 324 | 5.9e-84 | NTclustered | gi|1866582577|gb|MT730752.1| | 117822 | g42215 | i0 | 85.449 | 99.6024464831804 | 323 | 34 | 98 | 6 | 6 | 327 | 4073 | 4383 | Gallinipes pseudodichotomus isolate JEL0583 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 | 32570 | 324 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gallinipes | Gallinipes pseudodichotomus | |
| 8242723 | 8242723 | PRJNA611476_P_NODE_52607_length_301_cov_1.350877_g51816_i0 | PRJNA611476 | 52607 | 301 | 1.350877 | 4.06613977 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 281 | 3.28e-71 | NTclustered | gi|1027029543|ref|XR_001677161.1| | 645134 | g51816 | i0 | 94.054 | 75.0332225913621 | 185 | 11 | 61 | 0 | 1 | 185 | 3853 | 4037 | Spizellomyces punctatus DAOM BR117 28S ribosomal RNA (SPPG_11002), rRNA | blastn | 22585 | 281 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 13343247 | 13343247 | PRJNA611476_P_NODE_18491_length_461_cov_2.317010_g17701_i0 | PRJNA611476 | 18491 | 461 | 2.31701 | 10.6814161 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 449 | 1.36e-121 | NTclustered | gi|2432131711|ref|XM_053109357.1| | 110093 | g17701 | i0 | 85.548 | 91.1344902386117 | 429 | 62 | 93 | 0 | 1 | 429 | 151 | 579 | Polychytrium aggregatum calmodulin (BJ171DRAFT_488251), mRNA | blastn | 42013 | 449 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 18441567 | 18441567 | PRJNA611476_P_NODE_45275_length_321_cov_1.104839_g44484_i0 | PRJNA611476 | 45275 | 321 | 1.104839 | 3.54653319 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 195 | 4.73e-45 | NTclustered | gi|2432142886|ref|XM_053110559.1| | 110093 | g44484 | i0 | 79.054 | 74.4610591900312 | 296 | 52 | 90 | 7 | 34 | 321 | 38 | 331 | Polychytrium aggregatum 60S ribosomal protein L42 (BJ171DRAFT_500193), mRNA | blastn | 23902 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 20991712 | 20991712 | PRJNA611476_P_NODE_32757_length_363_cov_2.020690_g31966_i0 | PRJNA611476 | 32757 | 363 | 2.02069 | 7.3351047 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 222 | 2.48e-53 | NTclustered | gi|2432155310|ref|XM_053111519.1| | 110093 | g31966 | i0 | 79.808 | 26.7575757575758 | 312 | 57 | 85 | 6 | 55 | 363 | 404 | 96 | Polychytrium aggregatum 60S ribosomal protein L23 (BJ171DRAFT_510921), mRNA | blastn | 9713 | 222 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 22266455 | 22266455 | PRJNA611476_P_NODE_3018_length_1134_cov_3.472196_g2419_i0 | PRJNA611476 | 3018 | 1134 | 3.472196 | 39.37470264 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 193 | 6.52e-44 | NTclustered | gi|2432152794|ref|XM_053111383.1| | 110093 | g2419 | i0 | 78.477 | 6.30952380952381 | 302 | 59 | 26 | 6 | 480 | 778 | 497 | 199 | Polychytrium aggregatum ribosomal protein L23/L15e core domain-containing protein (BJ171DRAFT_509392), mRNA | blastn | 7155 | 193 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 24815823 | 24815823 | PRJNA611476_P_NODE_4700_length_892_cov_2.567766_g3988_i0 | PRJNA611476 | 4700 | 892 | 2.567766 | 22.90447272 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 287 | 2.2699999999999996e-72 | NTclustered | gi|2432149348|ref|XM_053111166.1| | 110093 | g3988 | i0 | 85.874 | 32.0179372197309 | 269 | 38 | 30 | 0 | 479 | 747 | 529 | 261 | Polychytrium aggregatum ribosomal protein S19-domain-containing protein (BJ171DRAFT_506928), mRNA | blastn | 28560 | 287 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum |
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);;