contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA631119" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3154181 | 3154181 | PRJNA631119_P_NODE_6463_length_455_cov_2.256545_g6345_i0 | PRJNA631119 | 6463 | 455 | 2.256545 | 10.26727975 | Neocallimastix frontalis | 4757 | Fungi | Fungi | 283 | 1.44e-71 | NTclustered | gi|387233100|gb|JN033860.1| | 4757 | g6345 | i0 | 78.587 | 63.3846153846154 | 453 | 80 | 98 | 16 | 10 | 455 | 987 | 545 | Neocallimastix frontalis strain PMA02 aconitate hydratase (AH1) mRNA, complete cds | blastn | 28840 | 283 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Neocallimastix | Neocallimastix frontalis | |
| 4430905 | 4430905 | PRJNA631119_P_NODE_20384_length_295_cov_1.189189_g20266_i0 | PRJNA631119 | 20384 | 295 | 1.189189 | 3.50810755 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 243 | 1.5100000000000001e-59 | NTclustered | gi|1759154564|ref|XM_031169821.1| | 1806994 | g20266 | i0 | 81.57 | 31.6508474576271 | 293 | 54 | 99 | 0 | 1 | 293 | 91 | 383 | Synchytrium microbalum uncharacterized protein (SmJEL517_g03893), partial mRNA | blastn | 9337 | 243 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 5706793 | 5706793 | PRJNA631119_P_NODE_20325_length_295_cov_1.387387_g20207_i0 | PRJNA631119 | 20325 | 295 | 1.387387 | 4.09279165 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 150 | 9.44e-32 | NTclustered | gi|2432177194|ref|XM_053112930.1| | 110093 | g20207 | i0 | 80.093 | 2.92203389830508 | 216 | 31 | 71 | 12 | 1 | 210 | 756 | 965 | Polychytrium aggregatum protein phosphatase 2A (BJ171DRAFT_539670), mRNA | blastn | 862 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 6981678 | 6981678 | PRJNA631119_P_NODE_28646_length_258_cov_2.875676_g28528_i0 | PRJNA631119 | 28646 | 258 | 2.875676 | 7.41924408 | Nowakowskiella sp. | 2012159 | Fungi | Fungi | 132 | 2.9300000000000003e-26 | NTclustered | gi|1866582490|gb|MT730665.1| | 2012159 | g28528 | i0 | 86.29 | 45.4767441860465 | 124 | 14 | 47 | 3 | 75 | 196 | 2235 | 2113 | Nowakowskiella sp. isolate JEL0078 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 | 11733 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Nowakowskiellaceae | Nowakowskiella | Nowakowskiella sp. | |
| 9531679 | 9531679 | PRJNA631119_P_NODE_17448_length_312_cov_1.623431_g17330_i0 | PRJNA631119 | 17448 | 312 | 1.623431 | 5.06510472 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 243 | 1.61e-59 | NTclustered | gi|2432132411|ref|XM_053109501.1| | 110093 | g17330 | i0 | 84.49 | 22.7916666666667 | 245 | 38 | 79 | 0 | 30 | 274 | 1174 | 930 | Polychytrium aggregatum ribosomal protein L3-domain-containing protein (BJ171DRAFT_489537), mRNA | blastn | 7111 | 243 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 13357340 | 13357340 | PRJNA631119_P_NODE_11191_length_367_cov_1.472789_g11073_i0 | PRJNA631119 | 11191 | 367 | 1.472789 | 5.40513563 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 387 | 8.409999999999998e-103 | NTclustered | gi|2432133245|ref|XM_053114647.1| | 110093 | g11073 | i0 | 85.912 | 97.4059945504087 | 362 | 51 | 99 | 0 | 3 | 364 | 1199 | 838 | Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_596045), mRNA | blastn | 35748 | 387 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 13357480 | 13357480 | PRJNA631119_P_NODE_36171_length_244_cov_3.672515_g36053_i0 | PRJNA631119 | 36171 | 244 | 3.672515 | 8.9609366 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 202 | 2.07e-47 | NTclustered | gi|2432129870|ref|XM_053107267.1| | 110093 | g36053 | i0 | 81.557 | 28.9754098360656 | 244 | 45 | 100 | 0 | 1 | 244 | 653 | 410 | Polychytrium aggregatum ribosomal protein S7 domain-containing protein (BJ171DRAFT_4084), mRNA | blastn | 7070 | 202 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 14632142 | 14632142 | PRJNA631119_P_NODE_2472_length_684_cov_3.857610_g2364_i0 | PRJNA631119 | 2472 | 684 | 3.85761 | 26.3860524 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 409 | 3.51e-109 | NTclustered | gi|2432156890|ref|XM_053107738.1| | 110093 | g2364 | i0 | 79.688 | 80.8523391812866 | 576 | 109 | 84 | 8 | 16 | 587 | 675 | 104 | Polychytrium aggregatum 60S ribosomal protein L2 (BJ171DRAFT_425809), partial mRNA | blastn | 55303 | 409 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 17181235 | 17181235 | PRJNA631119_P_NODE_31134_length_251_cov_0.865169_g31016_i0 | PRJNA631119 | 31134 | 251 | 0.865169 | 2.17157419 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 198 | 2.76e-46 | NTclustered | gi|2432149348|ref|XM_053111166.1| | 110093 | g31016 | i0 | 80.876 | 21.2669322709163 | 251 | 48 | 100 | 0 | 1 | 251 | 463 | 213 | Polychytrium aggregatum ribosomal protein S19-domain-containing protein (BJ171DRAFT_506928), mRNA | blastn | 5338 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 19729816 | 19729816 | PRJNA631119_P_NODE_24676_length_274_cov_6.731343_g24558_i0 | PRJNA631119 | 24676 | 274 | 6.731343 | 18.44387982 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 89.8 | 1.92e-13 | NTclustered | gi|2432158676|ref|XM_053113190.1| | 110093 | g24558 | i0 | 93.333 | 17.7919708029197 | 60 | 4 | 22 | 0 | 112 | 171 | 129 | 70 | Polychytrium aggregatum ribosomal protein S25 component of cytosolic 80S ribosome and 40S small subunit (BJ171DRAFT_559057), partial mRNA | blastn | 4875 | 89.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 22280248 | 22280248 | PRJNA631119_P_NODE_10218_length_379_cov_5.584967_g10100_i0 | PRJNA631119 | 10218 | 379 | 5.584967 | 21.16702493 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 195 | 5.67e-45 | NTclustered | gi|2432170888|ref|XM_053112523.1| | 110093 | g10100 | i0 | 77.126 | 26.0263852242744 | 341 | 74 | 89 | 4 | 40 | 378 | 43 | 381 | Polychytrium aggregatum putative 40S ribosomal protein S3 (BJ171DRAFT_522887), mRNA | blastn | 9864 | 195 | 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);;