contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA796639" and tax_phylum = "Basidiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2056436 | 2056436 | PRJNA796639_P_NODE_5402_length_253_cov_8.455556_g5277_i0 | PRJNA796639 | 5402 | 253 | 8.455556 | 21.39255668 | Puccinia triticina | 208348 | Fungi | Fungi | 359 | 1.21e-94 | NTclustered | gi|1714236267|ref|NC_044103.1| | 208348 | g5277 | i0 | 93.388 | 3.82608695652174 | 242 | 16 | 96 | 0 | 7 | 248 | 21543 | 21784 | Puccinia triticina isolate HnZU18-3 mitochondrion, complete genome | blastn | 968 | 359 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia triticina | |
| 2056453 | 2056453 | PRJNA796639_P_NODE_6462_length_247_cov_0.885057_g6337_i0 | PRJNA796639 | 6462 | 247 | 0.885057 | 2.18609079 | Ganoderma boninense | 34458 | Fungi | Fungi | 187 | 5.87e-43 | NTclustered | gi|1768663045|emb|LR729612.1| | 34458 | g6337 | i0 | 93.6 | 1.04048582995951 | 125 | 8 | 51 | 0 | 112 | 236 | 867 | 743 | Ganoderma boninense A7U5U4 gene for Hsp70 | blastn | 257 | 187 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma boninense | |
| 4608922 | 4608922 | PRJNA796639_P_NODE_7964_length_204_cov_4.702290_g7839_i0 | PRJNA796639 | 7964 | 204 | 4.70229 | 9.5926716 | Puccinia triticina | 208348 | Fungi | Fungi | 274 | 3.49e-69 | NTclustered | gi|1714236267|ref|NC_044103.1| | 208348 | g7839 | i0 | 91.5 | 4.84803921568627 | 200 | 15 | 98 | 2 | 1 | 200 | 45354 | 45157 | Puccinia triticina isolate HnZU18-3 mitochondrion, complete genome | blastn | 989 | 274 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia triticina | |
| 10984499 | 10984499 | PRJNA796639_P_NODE_7209_length_244_cov_0.900585_g7084_i0 | PRJNA796639 | 7209 | 244 | 0.900585 | 2.1974274 | Ganoderma boninense | 34458 | Fungi | Fungi | 255 | 1.5600000000000001e-63 | NTclustered | gi|1768652417|emb|LR723976.1| | 34458 | g7084 | i0 | 86.066 | 3.32377049180328 | 244 | 26 | 99 | 7 | 1 | 243 | 613 | 849 | Ganoderma boninense Q52CS0 gene for Ubiquitin-like modifier-activating enzyme ATG7 (ATG12-activating enzyme E1 ATG7) (Autophagy-related protein 7) | blastn | 811 | 255 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma boninense | |
| 12260038 | 12260038 | PRJNA796639_P_NODE_5990_length_249_cov_0.875000_g5865_i0 | PRJNA796639 | 5990 | 249 | 0.875 | 2.17875 | Lentinus tigrinus | 5365 | Fungi | Fungi | 327 | 3.34e-85 | NTclustered | gi|2797368524|ref|XM_067678534.1| | 1328758 | g5865 | i0 | 90.476 | 2.98393574297189 | 252 | 18 | 100 | 4 | 1 | 249 | 603 | 355 | Lentinus tigrinus ALCF2SS1-7 uncharacterized protein (L226DRAFT_518000), partial mRNA | blastn | 743 | 327 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Lentinus | Lentinus tigrinus | |
| 16083047 | 16083047 | PRJNA796639_P_NODE_5213_length_258_cov_1.664865_g5088_i0 | PRJNA796639 | 5213 | 258 | 1.664865 | 4.2953517 | Puccinia triticina | 208348 | Fungi | Fungi | 178 | 3.71e-40 | NTclustered | gi|2436884909|ref|XM_053170626.1| | 208348 | g5088 | i0 | 79.537 | 1.00387596899225 | 259 | 46 | 99 | 7 | 3 | 258 | 1515 | 1769 | Puccinia triticina uncharacterized protein (PtA15_6A876), partial mRNA | blastn | 259 | 178 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia triticina | |
| 19907328 | 19907328 | PRJNA796639_P_NODE_5336_length_255_cov_1.692308_g5211_i0 | PRJNA796639 | 5336 | 255 | 1.692308 | 4.3153854 | Austropuccinia psidii | 181123 | Fungi | Fungi | 185 | 2.19e-42 | NTclustered | gi|1714236393|ref|NC_044121.1| | 181123 | g5211 | i0 | 92.424 | 2.96078431372549 | 132 | 7 | 51 | 3 | 123 | 252 | 30143 | 30273 | Austropuccinia psidii isolate MF-1 mitochondrion, complete genome | blastn | 755 | 185 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Sphaerophragmiaceae | Austropuccinia | Austropuccinia psidii | |
| 21182991 | 21182991 | PRJNA796639_P_NODE_5057_length_262_cov_2.444444_g4932_i0 | PRJNA796639 | 5057 | 262 | 2.444444 | 6.40444328 | Puccinia kuehnii | 133750 | Fungi | Fungi | 379 | 9.649999999999998e-101 | NTclustered | gi|290543698|gb|GU171452.1| | 133750 | g4932 | i0 | 93.75 | 5.19847328244275 | 256 | 10 | 96 | 4 | 5 | 256 | 56 | 309 | Puccinia kuehnii microsatellite Stv_Puk_164 sequence | blastn | 1362 | 379 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia kuehnii |
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);;