contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1025141" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 162729 | 162729 | PRJNA1025141_P_NODE_1381_length_703_cov_1.628571_g1325_i0 | PRJNA1025141 | 1381 | 703 | 1.628571 | 11.44885413 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 302 | 6.320000000000001e-77 | NTclustered | gi|2432132579|ref|XM_053106383.1| | 110093 | g1325 | i0 | 80.867 | 45.3200568990043 | 392 | 67 | 55 | 8 | 2 | 389 | 1374 | 1761 | Polychytrium aggregatum heat shock protein 70 family (BJ171DRAFT_212372), mRNA | blastn | 31860 | 302 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 9090330 | 9090330 | PRJNA1025141_P_NODE_13248_length_236_cov_2.834356_g13187_i0 | PRJNA1025141 | 13248 | 236 | 2.834356 | 6.68908016 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 119 | 2.0600000000000001e-22 | NTclustered | gi|2432138713|ref|XM_053107478.1| | 110093 | g13187 | i0 | 84.127 | 8.26271186440678 | 126 | 16 | 53 | 3 | 113 | 236 | 148 | 25 | Polychytrium aggregatum large subunit ribosomal protein 29 (BJ171DRAFT_421272), partial mRNA | blastn | 1950 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 10365981 | 10365981 | PRJNA1025141_P_NODE_1589_length_658_cov_3.770940_g1530_i0 | PRJNA1025141 | 1589 | 658 | 3.77094 | 24.8127852 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 195 | 1.03e-44 | NTclustered | gi|2432162630|ref|XM_053112000.1| | 110093 | g1530 | i0 | 76.238 | 21.1595744680851 | 404 | 74 | 60 | 16 | 76 | 471 | 134 | 523 | Polychytrium aggregatum ribosomal protein L22/L17 (BJ171DRAFT_515986), mRNA | blastn | 13923 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 11641415 | 11641415 | PRJNA1025141_P_NODE_4830_length_369_cov_1.841216_g4769_i0 | PRJNA1025141 | 4830 | 369 | 1.841216 | 6.79408704 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 243 | 1.94e-59 | NTclustered | gi|2432145256|ref|XM_053110808.1| | 110093 | g4769 | i0 | 78.723 | 96.4336043360434 | 376 | 70 | 99 | 8 | 2 | 369 | 1545 | 1172 | Polychytrium aggregatum hsp71-like protein (BJ171DRAFT_502900), mRNA | blastn | 35584 | 243 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 12916454 | 12916454 | PRJNA1025141_P_NODE_11451_length_245_cov_1.343023_g11390_i0 | PRJNA1025141 | 11451 | 245 | 1.343023 | 3.29040635 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 130 | 9.93e-26 | NTclustered | gi|2432135813|ref|XM_053108310.1| | 110093 | g11390 | i0 | 79.255 | 9.15918367346939 | 188 | 37 | 76 | 2 | 59 | 245 | 355 | 169 | Polychytrium aggregatum CPS1 protein (BJ171DRAFT_456198), mRNA | blastn | 2244 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 15031854 | 15031854 | PRJNA1025141_P_NODE_1672_length_641_cov_1.091549_g1612_i0 | PRJNA1025141 | 1672 | 641 | 1.091549 | 6.99682909 | Fungi | 4751 | Fungi | Fungi | 403 | 1.5299999999999995e-107 | NTclustered | gi|2432080769|ref|XM_053070516.1| | 1396493 | g1612 | i0 | 79.478 | 84.7004680187208 | 575 | 112 | 89 | 5 | 1 | 572 | 539 | 1110 | Fimicolochytrium jonesii mitochondrial carrier domain-containing protein (EV422DRAFT_532223), mRNA | blastn | 54293 | 403 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 16739651 | 16739651 | PRJNA1025141_P_NODE_1094_length_786_cov_1.377279_g1043_i0 | PRJNA1025141 | 1094 | 786 | 1.377279 | 10.82541294 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 483 | 2.36e-131 | NTclustered | gi|2432130198|ref|XM_053115874.1| | 110093 | g1043 | i0 | 78.61 | 93.3778625954198 | 734 | 153 | 93 | 4 | 55 | 786 | 468 | 1199 | Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_7386), mRNA | blastn | 73395 | 483 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 20563901 | 20563901 | PRJNA1025141_P_NODE_12177_length_243_cov_1.788235_g12116_i0 | PRJNA1025141 | 12177 | 243 | 1.788235 | 4.34541105 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 122 | 1.6499999999999995e-23 | NTclustered | gi|2432129762|ref|XM_053108984.1| | 110093 | g12116 | i0 | 79.558 | 0.744855967078189 | 181 | 29 | 73 | 7 | 3 | 179 | 158 | 334 | Polychytrium aggregatum 60S ribosomal protein L37 (BJ171DRAFT_484391), mRNA | blastn | 181 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 20564037 | 20564037 | PRJNA1025141_P_NODE_8917_length_259_cov_1.758065_g8856_i0 | PRJNA1025141 | 8917 | 259 | 1.758065 | 4.55338835 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 132 | 2.95e-26 | NTclustered | gi|2432170888|ref|XM_053112523.1| | 110093 | g8856 | i0 | 76.763 | 5.77606177606178 | 241 | 52 | 92 | 4 | 1 | 239 | 89 | 327 | Polychytrium aggregatum putative 40S ribosomal protein S3 (BJ171DRAFT_522887), mRNA | blastn | 1496 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 21839609 | 21839609 | PRJNA1025141_P_NODE_1218_length_749_cov_1.107988_g1163_i0 | PRJNA1025141 | 1218 | 749 | 1.107988 | 8.29883012 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 424 | 1.38e-113 | NTclustered | gi|2432080769|ref|XM_053070516.1| | 1396493 | g1163 | i0 | 81.031 | 70.8384512683578 | 543 | 93 | 72 | 7 | 106 | 646 | 1106 | 572 | Fimicolochytrium jonesii mitochondrial carrier domain-containing protein (EV422DRAFT_532223), mRNA | blastn | 53058 | 424 | 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);;