contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA770826" and tax_phylum = "Zoopagomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10950960 | 10950960 | PRJNA770826_P_NODE_20329_length_179_cov_2.000000_g20158_i0 | PRJNA770826 | 20329 | 179 | 2 | 3.58 | Linderina pennispora | 61395 | Fungi | Fungi | 141 | 3.15e-29 | NTclustered | gi|2028319608|ref|XM_040887421.1| | 61395 | g20158 | i0 | 81.215 | 30.463687150838 | 181 | 28 | 99 | 6 | 2 | 179 | 312 | 135 | Linderina pennispora L30e-like protein (DL89DRAFT_267261), mRNA | blastn | 5453 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 13500615 | 13500615 | PRJNA770826_P_NODE_18831_length_187_cov_1.000000_g18660_i0 | PRJNA770826 | 18831 | 187 | 1 | 1.87 | Kickxella alabastrina | 61397 | Fungi | Fungi | 163 | 7.09e-36 | NTclustered | gi|2324014375|ref|XM_051535925.1| | 61397 | g18660 | i0 | 83.721 | 27.3689839572192 | 172 | 28 | 92 | 0 | 12 | 183 | 358 | 529 | Kickxella alabastrina Gar1/Naf1 RNA binding region-domain-containing protein (BX661DRAFT_182214), mRNA | blastn | 5118 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 13500747 | 13500747 | PRJNA770826_P_NODE_8851_length_272_cov_1.399103_g8680_i0 | PRJNA770826 | 8851 | 272 | 1.399103 | 3.80556016 | Kickxella alabastrina | 61397 | Fungi | Fungi | 169 | 2.38e-37 | NTclustered | gi|2324017868|ref|XM_051533264.1| | 61397 | g8680 | i0 | 78.571 | 22.9963235294118 | 266 | 50 | 97 | 7 | 10 | 272 | 1369 | 1108 | Kickxella alabastrina seryl-tRNA synthetase (BX661DRAFT_154789), mRNA | blastn | 6255 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 16049579 | 16049579 | PRJNA770826_P_NODE_6073_length_340_cov_3.247423_g5902_i0 | PRJNA770826 | 6073 | 340 | 3.247423 | 11.0412382 | Linderina pennispora | 61395 | Fungi | Fungi | 193 | 1.81e-44 | NTclustered | gi|2028312556|ref|XM_040884444.1| | 61395 | g5902 | i0 | 84.536 | 65.0852941176471 | 194 | 30 | 57 | 0 | 77 | 270 | 241 | 48 | Linderina pennispora 40S ribosomal protein S27 (DL89DRAFT_220296), partial mRNA | blastn | 22129 | 193 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 16049608 | 16049608 | PRJNA770826_P_NODE_93_length_1927_cov_3.589457_g70_i0 | PRJNA770826 | 93 | 1927 | 3.589457 | 69.16883639 | Linderina pennispora | 61395 | Fungi | Fungi | 808 | 0 | NTclustered | gi|2028320692|ref|XM_040883687.1| | 61395 | g70 | i0 | 79.208 | 70.0970420342501 | 1212 | 214 | 62 | 25 | 326 | 1524 | 536 | 1722 | Linderina pennispora heat shock 70 kDa protein 2 (DL89DRAFT_162838), mRNA | blastn | 135077 | 808 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 18598638 | 18598638 | PRJNA770826_P_NODE_22435_length_170_cov_1.719008_g22264_i0 | PRJNA770826 | 22435 | 170 | 1.719008 | 2.9223136 | Linderina pennispora | 61395 | Fungi | Fungi | 169 | 1.35e-37 | NTclustered | gi|2028320666|ref|XM_040889247.1| | 61395 | g22264 | i0 | 85.987 | 57.2705882352941 | 157 | 22 | 92 | 0 | 14 | 170 | 179 | 23 | Linderina pennispora 60S ribosomal protein L11 (DL89DRAFT_274988), partial mRNA | blastn | 9736 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 23699973 | 23699973 | PRJNA770826_P_NODE_8579_length_277_cov_2.280702_g8408_i0 | PRJNA770826 | 8579 | 277 | 2.280702 | 6.31754454 | Linderina pennispora | 61395 | Fungi | Fungi | 110 | 1.49e-19 | NTclustered | gi|2028314590|ref|XM_040891227.1| | 61395 | g8408 | i0 | 79.355 | 11.9747292418773 | 155 | 32 | 56 | 0 | 43 | 197 | 47 | 201 | Linderina pennispora ribosomal 60S subunit protein L39 (DL89DRAFT_320715), partial mRNA | blastn | 3317 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 24973477 | 24973477 | PRJNA770826_P_NODE_17540_length_193_cov_1.444444_g17369_i0 | PRJNA770826 | 17540 | 193 | 1.444444 | 2.78777692 | Linderina pennispora | 61395 | Fungi | Fungi | 124 | 3.48e-24 | NTclustered | gi|2028311014|ref|XM_040889407.1| | 61395 | g17369 | i0 | 80.108 | 1.92227979274611 | 186 | 22 | 93 | 9 | 14 | 193 | 362 | 538 | Linderina pennispora ribosomal protein S6e (DL89DRAFT_276961), partial mRNA | blastn | 371 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora |
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);;