contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_phylum = "Blastocladiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 364187 | 364187 | PRJNA168635_P_NODE_10461_length_255_cov_2.864078_g10046_i0 | PRJNA168635 | 10461 | 255 | 2.864078 | 7.3033989 | Coelomycidium sp. 1 TP-2011 | 945699 | Fungi | Fungi | 121 | 6.259999999999999e-23 | NTclustered | gi|321173733|gb|HQ888714.1| | 945699 | g10046 | i0 | 81.875 | 15.3490196078431 | 160 | 13 | 78 | 6 | 110 | 255 | 685 | 842 | Coelomycidium sp. 1 TP-2011 18S ribosomal RNA gene, partial sequence | blastn | 3914 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Coelomycidium | Coelomycidium sp. 1 TP-2011 | |||
| 364300 | 364300 | PRJNA168635_P_NODE_15781_length_201_cov_15.151316_g15365_i0 | PRJNA168635 | 15781 | 201 | 15.151316 | 30.45414516 | Physoderma maydis | 276838 | Fungi | Fungi | 156 | 1.3e-33 | NTclustered | gi|626438334|ref|NR_119547.1| | 276838 | g15365 | i0 | 90.164 | 57.726368159204 | 122 | 8 | 59 | 3 | 2 | 119 | 187 | 308 | Physoderma maydis DUKE DUH0007932 ITS region; from reference material | blastn | 11603 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Physoderma | Physoderma maydis | |
| 4882322 | 4882322 | PRJNA168635_P_NODE_4824_length_384_cov_6.835821_g4420_i0 | PRJNA168635 | 4824 | 384 | 6.835821 | 26.24955264 | Blastocladiales | 4805 | Fungi | Fungi | 93.5 | 2.16e-14 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g4420 | i0 | 92.424 | 17.8098958333333 | 66 | 4 | 33 | 1 | 320 | 384 | 2802 | 2867 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 6839 | 93.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 5467912 | 5467912 | PRJNA168635_P_NODE_32685_length_160_cov_9.072072_g32269_i0 | PRJNA168635 | 32685 | 160 | 9.072072 | 14.5153152 | Blastocladiales sp. | 2692728 | Fungi | Fungi | 193 | 7.489999999999999e-45 | NTclustered | gi|2468790988|gb|OQ702914.1| | 2692728 | g32269 | i0 | 89.103 | 89.1 | 156 | 16 | 98 | 1 | 3 | 158 | 2306 | 2152 | Blastocladiales sp. isolate PSC224 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 | 14256 | 193 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiales sp. | |||
| 8018063 | 8018063 | PRJNA168635_P_NODE_6487_length_332_cov_4.855124_g6076_i0 | PRJNA168635 | 6487 | 332 | 4.855124 | 16.11901168 | Coelomomyces stegomyiae | 143960 | Fungi | Fungi | 150 | 1.08e-31 | NTclustered | gi|82398116|gb|DQ273767.1| | 143960 | g6076 | i0 | 81.868 | 48.5090361445783 | 182 | 29 | 74 | 4 | 133 | 310 | 2936 | 3117 | Coelomomyces stegomyiae isolate AFTOL-ID 18 28S ribosomal RNA gene, partial sequence | blastn | 16105 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces stegomyiae | |
| 9292396 | 9292396 | PRJNA168635_P_NODE_13408_length_221_cov_5.941860_g12992_i0 | PRJNA168635 | 13408 | 221 | 5.94186 | 13.1315106 | Allomyces arbusculus | 64504 | Fungi | Fungi | 124 | 4.09e-24 | NTclustered | gi|1405239019|ref|NG_027623.1| | 64504 | g12992 | i0 | 88.462 | 50.1221719457014 | 104 | 11 | 47 | 1 | 118 | 221 | 1657 | 1555 | Allomyces arbusculus UCBMG Brasil 2 28S rRNA gene, partial sequence; from reference material | blastn | 11077 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 10568739 | 10568739 | PRJNA168635_P_NODE_3689_length_436_cov_4.925065_g3289_i0 | PRJNA168635 | 3689 | 436 | 4.925065 | 21.4732834 | Coelomycidium sp. 3 TP-2011 | 945701 | Fungi | Fungi | 331 | 4.8300000000000004e-86 | NTclustered | gi|321173780|gb|HQ888761.1| | 945701 | g3289 | i0 | 82.353 | 13.243119266055 | 408 | 46 | 90 | 17 | 39 | 429 | 1 | 399 | Coelomycidium sp. 3 TP-2011 28S ribosomal RNA gene, partial sequence | blastn | 5774 | 331 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Coelomycidium | Coelomycidium sp. 3 TP-2011 | |||
| 13118161 | 13118161 | PRJNA168635_P_NODE_16591_length_196_cov_4.530612_g16175_i0 | PRJNA168635 | 16591 | 196 | 4.530612 | 8.87999952 | Coelomycidium sp. 3 TP-2011 | 945701 | Fungi | Fungi | 222 | 1.22e-53 | NTclustered | gi|321173780|gb|HQ888761.1| | 945701 | g16175 | i0 | 95.652 | 64.5561224489796 | 138 | 6 | 70 | 0 | 1 | 138 | 801 | 664 | Coelomycidium sp. 3 TP-2011 28S ribosomal RNA gene, partial sequence | blastn | 12653 | 222 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Coelomycidium | Coelomycidium sp. 3 TP-2011 | |||
| 13807707 | 13807707 | PRJNA168635_P_NODE_32431_length_161_cov_26.973214_g32015_i0 | PRJNA168635 | 32431 | 161 | 26.973214 | 43.42687454 | Catenariaceae | 109872 | Fungi | Fungi | 198 | 1.6199999999999999e-46 | NTclustered | gi|574611861|gb|KF700244.1| | 109876 | g32015 | i0 | 90.196 | 93.9813664596273 | 153 | 14 | 94 | 1 | 4 | 155 | 333 | 181 | Catenaria anguillulae isolate CICR-Pra.Warud 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 | 15131 | 200 | 0.99 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 15667193 | 15667193 | PRJNA168635_P_NODE_16073_length_200_cov_0.947020_g15657_i0 | PRJNA168635 | 16073 | 200 | 0.94702 | 1.89404 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 117 | 6.0700000000000005e-22 | NTclustered | gi|49066441|gb|AY635842.1| | 4808 | g15657 | i0 | 95.833 | 38.085 | 72 | 3 | 36 | 0 | 129 | 200 | 1384 | 1313 | Blastocladiella emersonii isolate AFTOL-ID 302 18S ribosomal RNA gene, partial sequence | blastn | 7617 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 15667630 | 15667630 | PRJNA168635_P_NODE_9333_length_273_cov_4.901786_g8918_i0 | PRJNA168635 | 9333 | 273 | 4.901786 | 13.38187578 | Allomyces arbusculus | 64504 | Fungi | Fungi | 207 | 5.05e-49 | NTclustered | gi|1405239019|ref|NG_027623.1| | 64504 | g8918 | i0 | 85.787 | 72 | 197 | 27 | 72 | 1 | 62 | 258 | 1467 | 1662 | Allomyces arbusculus UCBMG Brasil 2 28S rRNA gene, partial sequence; from reference material | blastn | 19656 | 207 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 16941548 | 16941548 | PRJNA168635_P_NODE_14274_length_213_cov_6.451220_g13858_i0 | PRJNA168635 | 14274 | 213 | 6.45122 | 13.7410986 | Coelomycidium sp. 1 TP-2011 | 945699 | Fungi | Fungi | 174 | 3.83e-39 | NTclustered | gi|321173733|gb|HQ888714.1| | 945699 | g13858 | i0 | 82.174 | 22.6431924882629 | 230 | 15 | 97 | 14 | 6 | 211 | 42 | 269 | Coelomycidium sp. 1 TP-2011 18S ribosomal RNA gene, partial sequence | blastn | 4823 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Coelomycidium | Coelomycidium sp. 1 TP-2011 | |||
| 16942038 | 16942038 | PRJNA168635_P_NODE_9134_length_277_cov_3.342105_g8719_i0 | PRJNA168635 | 9134 | 277 | 3.342105 | 9.25763085 | Coelomycidium sp. 1 TP-2011 | 945699 | Fungi | Fungi | 394 | 3.68e-105 | NTclustered | gi|321173733|gb|HQ888714.1| | 945699 | g8719 | i0 | 97.807 | 97.1696750902527 | 228 | 5 | 82 | 0 | 50 | 277 | 1058 | 831 | Coelomycidium sp. 1 TP-2011 18S ribosomal RNA gene, partial sequence | blastn | 26916 | 394 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Coelomycidium | Coelomycidium sp. 1 TP-2011 | |||
| 17632022 | 17632022 | PRJNA168635_P_NODE_8354_length_292_cov_6.835391_g7939_i0 | PRJNA168635 | 8354 | 292 | 6.835391 | 19.95934172 | Blastocladiaceae | 4806 | Fungi | Fungi | 207 | 5.46e-49 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g7939 | i0 | 99.13 | 44.3698630136986 | 115 | 1 | 63 | 0 | 178 | 292 | 2311 | 2425 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 12956 | 207 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 19490239 | 19490239 | PRJNA168635_P_NODE_12276_length_232_cov_30.147541_g11860_i0 | PRJNA168635 | 12276 | 232 | 30.147541 | 69.94229512 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 89.8 | 1.58e-13 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g11860 | i0 | 90.909 | 0.28448275862069 | 66 | 6 | 28 | 0 | 41 | 106 | 3624 | 3559 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 66 | 89.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 19490453 | 19490453 | PRJNA168635_P_NODE_23996_length_171_cov_3.606557_g23580_i0 | PRJNA168635 | 23996 | 171 | 3.606557 | 6.16721247 | Allomyces arbusculus | 64504 | Fungi | Fungi | 113 | 6.480000000000001e-21 | NTclustered | gi|1405239019|ref|NG_027623.1| | 64504 | g23580 | i0 | 85.321 | 53.9824561403509 | 109 | 16 | 64 | 0 | 1 | 109 | 1557 | 1449 | Allomyces arbusculus UCBMG Brasil 2 28S rRNA gene, partial sequence; from reference material | blastn | 9231 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 22041316 | 22041316 | PRJNA168635_P_NODE_4698_length_389_cov_3.826471_g4294_i0 | PRJNA168635 | 4698 | 389 | 3.826471 | 14.88497219 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 135 | 3.59e-27 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g4294 | i0 | 89.623 | 25.452442159383 | 106 | 11 | 27 | 0 | 284 | 389 | 3371 | 3266 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 9901 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 22731014 | 22731014 | PRJNA168635_P_NODE_20878_length_179_cov_3.684615_g20462_i0 | PRJNA168635 | 20878 | 179 | 3.684615 | 6.59546085 | Allomyces | 28581 | Fungi | Fungi | 217 | 5.0799999999999996e-52 | NTclustered | gi|777407|gb|U23936.1|AMU23936 | 28583 | g20462 | i0 | 88.525 | 87.0502793296089 | 183 | 15 | 100 | 4 | 1 | 179 | 216 | 36 | Allomyces macrogynus small subunit ribosomal RNA (rns) gene, complete sequence | blastn | 15582 | 217 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 25280198 | 25280198 | PRJNA168635_P_NODE_13000_length_225_cov_3.568182_g12584_i0 | PRJNA168635 | 13000 | 225 | 3.568182 | 8.0284095 | Fungi | 4751 | Fungi | Fungi | 141 | 4.15e-29 | NTclustered | gi|321173721|gb|HQ888702.1| | 945686 | g12584 | i0 | 90.654 | 43.3111111111111 | 107 | 9 | 47 | 1 | 2 | 107 | 1215 | 1321 | Catenaria spinosa strain WM100 18S ribosomal RNA gene, partial sequence | blastn | 9745 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria spinosa |
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);;