contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA638724" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1155359 | 1155359 | PRJNA638724_P_NODE_7221_length_244_cov_1.362573_g7135_i0 | PRJNA638724 | 7221 | 244 | 1.362573 | 3.32467812 | Aspergillus | 5052 | Fungi | Fungi | 267 | 7.219999999999999e-67 | NTclustered | gi|2086739434|ref|XM_043281145.1| | 182096 | g7135 | i0 | 88.053 | 26.3852459016393 | 226 | 25 | 92 | 2 | 11 | 235 | 1103 | 879 | Aspergillus chevalieri aldehyde dehydrogenase (NAD(P)(+)) ald5 (ALD5_1), partial mRNA | blastn | 6438 | 267 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri | |
| 2430525 | 2430525 | PRJNA638724_P_NODE_6922_length_247_cov_3.091954_g6836_i0 | PRJNA638724 | 6922 | 247 | 3.091954 | 7.63712638 | Aspergillus | 5052 | Fungi | Fungi | 409 | 1.1499999999999998e-109 | NTclustered | gi|415318|emb|Z27114.1| | 162425 | g6836 | i0 | 97.89 | 85.1902834008097 | 237 | 4 | 96 | 1 | 1 | 237 | 424 | 189 | A.nidulans gene for 28S ribosomal RNA and 18S ribosomal RNA | blastn | 21042 | 411 | 0.995133819951338 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus nidulans | |
| 3706985 | 3706985 | PRJNA638724_P_NODE_8163_length_224_cov_5.344371_g8077_i0 | PRJNA638724 | 8163 | 224 | 5.344371 | 11.97139104 | Aspergillus | 5052 | Fungi | Fungi | 396 | 7.979999999999997e-106 | NTclustered | gi|2086743560|ref|XR_006253225.1| | 182096 | g8077 | i0 | 99.541 | 102.955357142857 | 218 | 0 | 97 | 1 | 1 | 217 | 2934 | 2717 | Aspergillus chevalieri 28S ribosomal RNA (ACHE_r70002S), rRNA | blastn | 23062 | 396 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri | |
| 4437308 | 4437308 | PRJNA638724_P_NODE_6804_length_249_cov_0.875000_g6718_i0 | PRJNA638724 | 6804 | 249 | 0.875 | 2.17875 | Aspergillus magnivesiculatus | 1915373 | Fungi | Fungi | 425 | 1.15e-114 | NTclustered | gi|2666209007|dbj|LC797028.1| | 1915373 | g6718 | i0 | 98.745 | 55.1325301204819 | 239 | 3 | 96 | 0 | 1 | 239 | 11298 | 11060 | Aspergillus magnivesiculatus NBRC 116037 mitochondrial DNA, complete genome | blastn | 13728 | 425 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus magnivesiculatus | |
| 4437312 | 4437312 | PRJNA638724_P_NODE_7244_length_244_cov_0.900585_g7158_i0 | PRJNA638724 | 7244 | 244 | 0.900585 | 2.1974274 | Alternaria alternata | 5599 | Fungi | Fungi | 350 | 6.969999999999998e-92 | NTclustered | gi|1070540379|ref|XM_018524034.1| | 5599 | g7158 | i0 | 96.244 | 2.58196721311475 | 213 | 8 | 87 | 0 | 22 | 234 | 1332 | 1120 | Alternaria alternata hypothetical protein mRNA | blastn | 630 | 350 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 10083839 | 10083839 | PRJNA638724_P_NODE_7688_length_237_cov_2.451220_g7602_i0 | PRJNA638724 | 7688 | 237 | 2.45122 | 5.8093914 | Cladosporium | 5498 | Fungi | Fungi | 424 | 3.91e-114 | NTclustered | gi|283827952|gb|EU019262.2| | 29917 | g7602 | i0 | 100 | 62.0464135021097 | 229 | 0 | 97 | 0 | 1 | 229 | 3258 | 3030 | Cladosporium cladosporioides strain CBS 109.21 28S large subunit ribosomal RNA gene, partial sequence | blastn | 14705 | 424 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 10813782 | 10813782 | PRJNA638724_P_NODE_6969_length_247_cov_0.885057_g6883_i0 | PRJNA638724 | 6969 | 247 | 0.885057 | 2.18609079 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 58.4 | 4.8e-4 | NTclustered | gi|2837755403|ref|XM_069374405.1| | 1052096 | g6883 | i0 | 92.5 | 0.161943319838057 | 40 | 3 | 16 | 0 | 176 | 215 | 1415 | 1454 | Cladosporium halotolerans uncharacterized protein (WHR41_05800), mRNA | blastn | 40 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 11358742 | 11358742 | PRJNA638724_P_NODE_1189_length_525_cov_2.630531_g1104_i0 | PRJNA638724 | 1189 | 525 | 2.630531 | 13.81028775 | Dothideomycetes | 147541 | Fungi | Fungi | 952 | 0 | NTclustered | gi|1840379205|gb|MT453271.1| | 5599 | g1104 | i0 | 100 | 98.0952380952381 | 515 | 0 | 98 | 0 | 1 | 515 | 1081 | 567 | Alternaria alternata isolate DSM100286_DF09_RLCS10 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 | 51500 | 952 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 11358748 | 11358748 | PRJNA638724_P_NODE_8049_length_228_cov_4.529032_g7963_i0 | PRJNA638724 | 8049 | 228 | 4.529032 | 10.32619296 | Aspergillus | 5052 | Fungi | Fungi | 422 | 1.34e-113 | NTclustered | gi|2771821340|gb|PQ047497.1| | 5065 | g7963 | i0 | 100 | 100.517543859649 | 228 | 0 | 100 | 0 | 1 | 228 | 377 | 150 | Aspergillus sp. isolate DKA63 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 | 22918 | 422 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus sp. | |
| 13909285 | 13909285 | PRJNA638724_P_NODE_8311_length_213_cov_10.714286_g8225_i0 | PRJNA638724 | 8311 | 213 | 10.714286 | 22.82142918 | root | 1 | Root_unresolved | Root_unresolved | 379 | 7.569999999999999e-101 | NTclustered | gi|323371153|gb|GU733352.1| | 5054 | g8225 | i0 | 100 | 96.2441314553991 | 205 | 0 | 96 | 0 | 1 | 205 | 1548 | 1344 | Aspergillus amstelodami strain CBS 518.65 18S ribosomal RNA gene, partial sequence | blastn | 20500 | 379 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus amstelodami | |
| 14638489 | 14638489 | PRJNA638724_P_NODE_7532_length_241_cov_0.916667_g7446_i0 | PRJNA638724 | 7532 | 241 | 0.916667 | 2.20916747 | Aspergillus pseudodeflectus | 176178 | Fungi | Fungi | 237 | 5.58e-58 | NTclustered | gi|2897757729|ref|XM_071037293.1| | 176178 | g7446 | i0 | 85.217 | 9.58921161825726 | 230 | 34 | 95 | 0 | 2 | 231 | 4062 | 3833 | Aspergillus pseudodeflectus NUC071 domain-containing protein (BJX68DRAFT_185745), mRNA | blastn | 2311 | 237 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus pseudodeflectus | |
| 17187520 | 17187520 | PRJNA638724_P_NODE_3074_length_350_cov_1.700361_g2988_i0 | PRJNA638724 | 3074 | 350 | 1.700361 | 5.9512635 | Aspergillus clavatophorus | 1915367 | Fungi | Fungi | 628 | 1.1999999999999999e-175 | NTclustered | gi|2666209001|dbj|LC797027.1| | 1915367 | g2988 | i0 | 100 | 98.0171428571429 | 340 | 0 | 97 | 0 | 1 | 340 | 20750 | 20411 | Aspergillus clavatophorus NBRC 116038 mitochondrial DNA, complete genome | blastn | 34306 | 628 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus clavatophorus | |
| 17187527 | 17187527 | PRJNA638724_P_NODE_7254_length_244_cov_0.894737_g7168_i0 | PRJNA638724 | 7254 | 244 | 0.894737 | 2.18315828 | Aspergillus clavatophorus | 1915367 | Fungi | Fungi | 427 | 3.13e-115 | NTclustered | gi|2666209001|dbj|LC797027.1| | 1915367 | g7168 | i0 | 99.573 | 17.3811475409836 | 234 | 1 | 96 | 0 | 1 | 234 | 22650 | 22883 | Aspergillus clavatophorus NBRC 116038 mitochondrial DNA, complete genome | blastn | 4241 | 427 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus clavatophorus | |
| 17733189 | 17733189 | PRJNA638724_P_NODE_5494_length_273_cov_3.075000_g5408_i0 | PRJNA638724 | 5494 | 273 | 3.075 | 8.39475 | Eukaryota | 2759 | Fungi | Fungi | 505 | 1.6e-138 | NTclustered | gi|33334380|gb|AF548066.1| | 41959 | g5408 | i0 | 100 | 100.007326007326 | 273 | 0 | 100 | 0 | 1 | 273 | 34 | 306 | Aspergillus penicillioides strain ALI 231 18S ribosomal RNA gene, partial sequence | blastn | 27302 | 505 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus penicillioides | |
| 22286673 | 22286673 | PRJNA638724_P_NODE_4398_length_300_cov_1.215859_g4312_i0 | PRJNA638724 | 4398 | 300 | 1.215859 | 3.647577 | Aspergillus magnivesiculatus | 1915373 | Fungi | Fungi | 525 | 1.3699999999999995e-144 | NTclustered | gi|2666209007|dbj|LC797028.1| | 1915373 | g4312 | i0 | 99.31 | 99.3233333333333 | 290 | 2 | 97 | 0 | 11 | 300 | 18703 | 18414 | Aspergillus magnivesiculatus NBRC 116037 mitochondrial DNA, complete genome | blastn | 29797 | 525 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus magnivesiculatus | |
| 24835900 | 24835900 | PRJNA638724_P_NODE_4580_length_295_cov_2.189189_g4494_i0 | PRJNA638724 | 4580 | 295 | 2.189189 | 6.45810755 | Aspergillus penicillioides | 41959 | Fungi | Fungi | 529 | 1.0399999999999996e-145 | NTclustered | gi|984294657|gb|KT390118.1| | 41959 | g4494 | i0 | 98.983 | 99.7796610169491 | 295 | 3 | 100 | 0 | 1 | 295 | 1237 | 943 | Aspergillus penicillioides clone KJ34-0.2-39 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 29435 | 529 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus penicillioides | |
| 24835903 | 24835903 | PRJNA638724_P_NODE_6900_length_248_cov_0.880000_g6814_i0 | PRJNA638724 | 6900 | 248 | 0.88 | 2.1824 | Aspergillus chevalieri | 182096 | Fungi | Fungi | 261 | 3.42e-65 | NTclustered | gi|2086734118|ref|XM_043278192.1| | 182096 | g6814 | i0 | 86.498 | 6.89516129032258 | 237 | 32 | 96 | 0 | 1 | 237 | 918 | 682 | Aspergillus chevalieri uncharacterized protein (ACHE_40037A), partial mRNA | blastn | 1710 | 261 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri |
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);;