contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA393181" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6181512 | 6181512 | PRJNA393181_S_NODE_29805_length_206_cov_1.544379_g29699_i0 | PRJNA393181 | 29805 | 206 | 1.544379 | 3.18142074 | Cladosporium | 5498 | Fungi | Fungi | 381 | 2.0199999999999994e-101 | NTclustered | gi|1401690641|gb|MH474001.1| | 29917 | g29699 | i0 | 100 | 100 | 206 | 0 | 100 | 0 | 1 | 206 | 224 | 19 | Cladosporium cladosporioides isolate CK1359 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 20600 | 381 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 7456466 | 7456466 | PRJNA393181_S_NODE_31586_length_198_cov_1.826087_g31480_i0 | PRJNA393181 | 31586 | 198 | 1.826087 | 3.61565226 | Dothideomycetes | 147541 | Fungi | Fungi | 361 | 2.51e-95 | NTclustered | gi|283827932|gb|FJ493209.2| | 630509 | g31480 | i0 | 99.495 | 99.7626262626263 | 198 | 1 | 100 | 0 | 1 | 198 | 2134 | 1937 | Phaeophleospora eugeniicola strain CPC 2558 28S large subunit ribosomal RNA gene, partial sequence | blastn | 19753 | 361 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Phaeophleospora | Phaeophleospora eugeniicola | |
| 10614698 | 10614698 | PRJNA393181_S_NODE_44329_length_158_cov_1.289256_g44223_i0 | PRJNA393181 | 44329 | 158 | 1.289256 | 2.03702448 | Cladosporium anthropophilum | 1970646 | Fungi | Fungi | 254 | 3.3400000000000003e-63 | NTclustered | gi|2216737164|ref|NC_061970.1| | 1970646 | g44223 | i0 | 95.57 | 87.6329113924051 | 158 | 7 | 100 | 0 | 1 | 158 | 4738 | 4581 | Cladosporium anthropophilum voucher KACC 49782 mitochondrion, complete genome | blastn | 13846 | 254 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium anthropophilum | |
| 13831865 | 13831865 | PRJNA393181_S_NODE_22051_length_249_cov_1.292453_g21945_i0 | PRJNA393181 | 22051 | 249 | 1.292453 | 3.21820797 | Fusarium | 5506 | Fungi | Fungi | 182 | 2.75e-41 | NTclustered | gi|1070343524|ref|XM_018389999.1| | 426428 | g21945 | i0 | 80.952 | 61.1044176706827 | 231 | 42 | 92 | 2 | 1 | 230 | 678 | 449 | Fusarium oxysporum f. sp. lycopersici 4287 60S ribosomal protein L7 (FOXG_10571), mRNA | blastn | 15215 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium oxysporum | |
| 23363124 | 23363124 | PRJNA393181_S_NODE_7839_length_426_cov_2.753213_g7733_i0 | PRJNA393181 | 7839 | 426 | 2.753213 | 11.72868738 | Diutina rugosa | 5481 | Fungi | Fungi | 52.8 | 0.041 | NTclustered | gi|1838467306|ref|XM_034154283.1| | 5481 | g7733 | i0 | 92.105 | 3.03286384976526 | 38 | 2 | 9 | 1 | 186 | 223 | 120 | 156 | Diutina rugosa uncharacterized protein (DIURU_000171), partial mRNA | blastn | 1292 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Diutina | Diutina rugosa | |
| 24637255 | 24637255 | PRJNA393181_S_NODE_45340_length_155_cov_2.940678_g45234_i0 | PRJNA393181 | 45340 | 155 | 2.940678 | 4.5580509 | Diaporthe batatas | 748121 | Fungi | Fungi | 82.4 | 1.63e-11 | NTclustered | gi|2124364152|ref|XM_044788593.1| | 748121 | g45234 | i0 | 96 | 8.84516129032258 | 50 | 2 | 32 | 0 | 106 | 155 | 626 | 675 | Diaporthe batatas uncharacterized protein (KVR01_004153), mRNA | blastn | 1371 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Diaporthaceae | Diaporthe | Diaporthe batatas |
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);;