contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA195897" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2916645 | 2916645 | PRJNA195897_P_NODE_263_length_1000_cov_2.234490_g244_i0 | PRJNA195897 | 263 | 1000 | 2.23449 | 22.3449 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 503 | 2.33e-137 | NTclustered | gi|2432130198|ref|XM_053115874.1| | 110093 | g244 | i0 | 76.856 | 85.841 | 916 | 196 | 91 | 14 | 3 | 910 | 1148 | 241 | Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_7386), mRNA | blastn | 85841 | 503 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 4193035 | 4193035 | PRJNA195897_P_NODE_11184_length_165_cov_0.879310_g11151_i0 | PRJNA195897 | 11184 | 165 | 0.87931 | 1.4508615 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 56.5 | 0.001 | NTclustered | gi|2432078369|ref|XM_053074308.1| | 1396493 | g11151 | i0 | 90.476 | 0.806060606060606 | 42 | 4 | 25 | 0 | 1 | 42 | 79 | 38 | Fimicolochytrium jonesii uncharacterized protein (EV422DRAFT_68862), mRNA | blastn | 133 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 8019359 | 8019359 | PRJNA195897_P_NODE_3787_length_247_cov_3.121212_g3754_i0 | PRJNA195897 | 3787 | 247 | 3.121212 | 7.70939364 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 246 | 9.54e-61 | NTclustered | gi|2432143306|ref|XM_053110608.1| | 110093 | g3754 | i0 | 88.614 | 30.331983805668 | 202 | 23 | 82 | 0 | 10 | 211 | 326 | 125 | Polychytrium aggregatum putative 40S ribosomal protein RPS14 (BJ171DRAFT_500769), mRNA | blastn | 7492 | 246 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 16943259 | 16943259 | PRJNA195897_P_NODE_3114_length_278_cov_1.646288_g3081_i0 | PRJNA195897 | 3114 | 278 | 1.646288 | 4.57668064 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 152 | 2.45e-32 | NTclustered | gi|2432058563|ref|XM_053065718.1| | 1396493 | g3081 | i0 | 83.436 | 1.61151079136691 | 163 | 27 | 59 | 0 | 62 | 224 | 92 | 254 | Fimicolochytrium jonesii 40S ribosomal protein S28 (EV422DRAFT_248144), mRNA | blastn | 448 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 16943318 | 16943318 | PRJNA195897_P_NODE_9834_length_167_cov_1.322034_g9801_i0 | PRJNA195897 | 9834 | 167 | 1.322034 | 2.20779678 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 141 | 2.91e-29 | NTclustered | gi|2432143906|ref|XM_053110665.1| | 110093 | g9801 | i0 | 86.364 | 27.1017964071856 | 132 | 14 | 78 | 4 | 2 | 131 | 169 | 40 | Polychytrium aggregatum cyclophilin-like domain-containing protein (BJ171DRAFT_501438), mRNA | blastn | 4526 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 19491944 | 19491944 | PRJNA195897_P_NODE_1336_length_459_cov_1.429268_g1303_i0 | PRJNA195897 | 1336 | 459 | 1.429268 | 6.56034012 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 224 | 8.919999999999998e-54 | NTclustered | gi|2432131389|ref|XM_053109302.1| | 110093 | g1303 | i0 | 78.512 | 0.790849673202614 | 363 | 63 | 78 | 10 | 88 | 444 | 136 | 489 | Polychytrium aggregatum ribosomal protein S3Ae (BJ171DRAFT_487525), mRNA | blastn | 363 | 224 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 19492007 | 19492007 | PRJNA195897_P_NODE_616_length_690_cov_8.065523_g586_i0 | PRJNA195897 | 616 | 690 | 8.065523 | 55.6521087 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 195 | 1.0800000000000001e-44 | NTclustered | gi|2432162630|ref|XM_053112000.1| | 110093 | g586 | i0 | 76.238 | 20.1782608695652 | 404 | 74 | 57 | 16 | 77 | 472 | 134 | 523 | Polychytrium aggregatum ribosomal protein L22/L17 (BJ171DRAFT_515986), mRNA | blastn | 13923 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 20767503 | 20767503 | PRJNA195897_P_NODE_2617_length_308_cov_7.324324_g2584_i0 | PRJNA195897 | 2617 | 308 | 7.324324 | 22.55891792 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 121 | 7.769999999999999e-23 | NTclustered | gi|2432138713|ref|XM_053107478.1| | 110093 | g2584 | i0 | 84.252 | 6.97077922077922 | 127 | 16 | 41 | 3 | 13 | 137 | 24 | 148 | Polychytrium aggregatum large subunit ribosomal protein 29 (BJ171DRAFT_421272), partial mRNA | blastn | 2147 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 24007269 | 24007269 | PRJNA195897_P_NODE_12539_length_162_cov_0.920354_g12506_i0 | PRJNA195897 | 12539 | 162 | 0.920354 | 1.49097348 | Fungi | 4751 | Fungi | Fungi | 191 | 2.74e-44 | NTclustered | gi|2432130120|ref|XM_053107963.1| | 110093 | g12506 | i0 | 88.535 | 21.3024691358025 | 157 | 18 | 97 | 0 | 6 | 162 | 987 | 831 | Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_436912), mRNA | blastn | 3451 | 191 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 24592173 | 24592173 | PRJNA195897_P_NODE_10080_length_167_cov_0.881356_g10047_i0 | PRJNA195897 | 10080 | 167 | 0.881356 | 1.47186452 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 152 | 1.3399999999999998e-32 | NTclustered | gi|2432153160|ref|XM_053111407.1| | 110093 | g10047 | i0 | 83.133 | 24.5508982035928 | 166 | 28 | 99 | 0 | 2 | 167 | 413 | 248 | Polychytrium aggregatum protein RPL-30, isoform a (BJ171DRAFT_509631), mRNA | blastn | 4100 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 24592238 | 24592238 | PRJNA195897_P_NODE_5720_length_203_cov_2.025974_g5687_i0 | PRJNA195897 | 5720 | 203 | 2.025974 | 4.11272722 | Batrachochytrium dendrobatidis | 109871 | Fungi | Fungi | 76.8 | 1.05e-9 | NTclustered | gi|575479223|ref|XM_006678843.1| | 684364 | g5687 | i0 | 84.81 | 0.827586206896552 | 79 | 9 | 38 | 3 | 20 | 97 | 113 | 189 | Batrachochytrium dendrobatidis JAM81 uncharacterized protein (BATDEDRAFT_19546), mRNA | blastn | 168 | 76.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis |
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);;