contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA951810" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2211501 | 2211501 | PRJNA951810_P_NODE_151582_length_256_cov_10.136612_g151237_i0 | PRJNA951810 | 151582 | 256 | 10.136612 | 25.94972672 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|330804915|ref|XM_003290387.1| | 5786 | g151237 | i0 | 100 | 0.109375 | 28 | 0 | 11 | 0 | 70 | 97 | 189 | 216 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_81152), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 2211933 | 2211933 | PRJNA951810_P_NODE_180182_length_232_cov_2.402516_g179837_i0 | PRJNA951810 | 180182 | 232 | 2.402516 | 5.57383712 | Dictyostelium citrinum | 361072 | Evosea | other_Eukaryota | 135 | 2e-27 | NTclustered | gi|294662991|ref|NC_007787.2| | 361072 | g179837 | i0 | 82.209 | 18.2715517241379 | 163 | 23 | 68 | 6 | 31 | 188 | 21376 | 21537 | Dictyostelium citrinum mitochondrion, complete genome | blastn | 4239 | 135 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium citrinum | ||
| 2212490 | 2212490 | PRJNA951810_P_NODE_33462_length_344_cov_1.564576_g33120_i0 | PRJNA951810 | 33462 | 344 | 1.564576 | 5.38214144 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 453 | 7.630000000000001e-123 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g33120 | i0 | 90.407 | 98.3982558139535 | 344 | 33 | 100 | 0 | 1 | 344 | 758 | 1101 | Platyamoeba placida actin mRNA, partial cds | blastn | 33849 | 453 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 4766581 | 4766581 | PRJNA951810_P_NODE_93264_length_296_cov_4.197309_g92920_i0 | PRJNA951810 | 93264 | 296 | 4.197309 | 12.42403464 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 60.2 | 1.64e-4 | NTclustered | gi|470484210|ref|XM_004343996.1| | 1257118 | g92920 | i0 | 91.111 | 0.152027027027027 | 45 | 2 | 15 | 2 | 229 | 272 | 446 | 403 | Acanthamoeba castellanii str. Neff Peroxin 13 (Pex13), putative (ACA1_053870), partial mRNA | blastn | 45 | 60.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 6366947 | 6366947 | PRJNA951810_P_NODE_104525_length_290_cov_3.870968_g104181_i0 | PRJNA951810 | 104525 | 290 | 3.870968 | 11.2258072 | Didymium | 5792 | Evosea | other_Eukaryota | 462 | 1.05e-125 | NTclustered | gi|25989341|gb|AY062881.1| | 181200 | g104181 | i0 | 95.517 | 40.9034482758621 | 290 | 12 | 100 | 1 | 1 | 290 | 628 | 916 | Hyperamoeba dachnaya small subunit ribosomal RNA gene, partial sequence | blastn | 11862 | 462 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium dachnayum | ||
| 7315775 | 7315775 | PRJNA951810_P_NODE_65506_length_310_cov_2.780591_g65163_i0 | PRJNA951810 | 65506 | 310 | 2.780591 | 8.6198321 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 145 | 4.6399999999999994e-30 | NTclustered | gi|470531839|ref|XM_004358199.1| | 1257118 | g65163 | i0 | 84.828 | 0.670967741935484 | 145 | 20 | 46 | 2 | 1 | 144 | 435 | 292 | Acanthamoeba castellanii str. Neff thiF family protein (ACA1_085210), partial mRNA | blastn | 208 | 145 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 9864308 | 9864308 | PRJNA951810_P_NODE_157988_length_251_cov_5.297753_g157643_i0 | PRJNA951810 | 157988 | 251 | 5.297753 | 13.29736003 | Cribraria violacea | 1334538 | Evosea | other_Eukaryota | 248 | 2.7e-61 | NTclustered | gi|501417113|gb|JX481322.1| | 1334538 | g157643 | i0 | 84.706 | 88.1075697211155 | 255 | 31 | 100 | 7 | 1 | 251 | 761 | 511 | Cribraria violacea voucher AMFD172 elongation factor 1A (EF1A) gene, partial cds | blastn | 22115 | 248 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Liceales | Cribrariaceae | Cribraria | Cribraria violacea | ||
| 11139539 | 11139539 | PRJNA951810_P_NODE_134589_length_269_cov_10.183673_g134244_i0 | PRJNA951810 | 134589 | 269 | 10.183673 | 27.39408037 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 228 | 3.809999999999999e-55 | NTclustered | gi|470427085|ref|XM_004337911.1| | 1257118 | g134244 | i0 | 98.45 | 0.479553903345725 | 129 | 2 | 48 | 0 | 128 | 256 | 1539 | 1411 | Acanthamoeba castellanii str. Neff 4aminobutyrate aminotransferase (ACA1_321730), partial mRNA | blastn | 129 | 228 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 11467551 | 11467551 | PRJNA951810_P_NODE_34569_length_337_cov_5.189394_g34226_i0 | PRJNA951810 | 34569 | 337 | 5.189394 | 17.48825778 | Ripella | 1217112 | Discosea | other_Eukaryota | 520 | 7.249999999999999e-143 | NTclustered | gi|1269228350|gb|MF683475.1| | 2047821 | g34226 | i0 | 94.444 | 91.7329376854599 | 342 | 11 | 100 | 6 | 1 | 337 | 182 | 520 | Ripella platypodia clone 23.4.23 18S ribosomal RNA gene, partial sequence | blastn | 30914 | 520 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella platypodia | |||
| 12743104 | 12743104 | PRJNA951810_P_NODE_35930_length_329_cov_1.484375_g35587_i0 | PRJNA951810 | 35930 | 329 | 1.484375 | 4.88359375 | Flamella | 490353 | Evosea | other_Eukaryota | 608 | 1.4599999999999995e-169 | NTclustered | gi|163943978|gb|EU186022.1| | 490515 | g35587 | i0 | 100 | 98.8632218844985 | 329 | 0 | 100 | 0 | 1 | 329 | 687 | 1015 | Flamella arnhemensis 18S ribosomal RNA gene, partial sequence | blastn | 32526 | 608 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Flamella | Flamella arnhemensis | |||
| 13689476 | 13689476 | PRJNA951810_P_NODE_129771_length_273_cov_3.675000_g129426_i0 | PRJNA951810 | 129771 | 273 | 3.675 | 10.03275 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 148 | 3.11e-31 | NTclustered | gi|330805894|ref|XM_003290864.1| | 5786 | g129426 | i0 | 86.232 | 1.73626373626374 | 138 | 18 | 50 | 1 | 64 | 200 | 259 | 122 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_81609), partial mRNA | blastn | 474 | 148 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 16239262 | 16239262 | PRJNA951810_P_NODE_168773_length_243_cov_4.164706_g168428_i0 | PRJNA951810 | 168773 | 243 | 4.164706 | 10.12023558 | Didymium environmental sample | 1173723 | Evosea | other_Eukaryota | 121 | 5.92e-23 | NTclustered | gi|407196931|gb|JX545305.1| | 1173723 | g168428 | i0 | 77.391 | 19.0205761316872 | 230 | 35 | 90 | 11 | 26 | 243 | 1 | 225 | Didymium environmental sample clone HCA_D08-36 28S ribosomal RNA gene, partial sequence | blastn | 4622 | 121 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium environmental sample | |||
| 16239265 | 16239265 | PRJNA951810_P_NODE_168993_length_243_cov_2.882353_g168648_i0 | PRJNA951810 | 168993 | 243 | 2.882353 | 7.00411779 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 122 | 1.6499999999999995e-23 | NTclustered | gi|1160571044|ref|XM_020575016.1| | 670386 | g168648 | i0 | 81.046 | 1.16460905349794 | 153 | 29 | 63 | 0 | 89 | 241 | 435 | 283 | Polysphondylium pallidum PN500 40S ribosomal protein S14 (rps14), partial mRNA | blastn | 283 | 122 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 19115634 | 19115634 | PRJNA951810_P_NODE_90535_length_297_cov_4.343750_g90191_i0 | PRJNA951810 | 90535 | 297 | 4.34375 | 12.9009375 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 135 | 2.6600000000000003e-27 | NTclustered | gi|881634|gb|U29610.1|ACU29610 | 5755 | g90191 | i0 | 78.112 | 2.96969696969697 | 233 | 37 | 74 | 6 | 7 | 226 | 836 | 605 | Acanthaoeba castellanii actin-related protein 3 Arp3 mRNA, complete cds | blastn | 882 | 135 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 20064717 | 20064717 | PRJNA951810_P_NODE_79356_length_299_cov_4.402655_g79012_i0 | PRJNA951810 | 79356 | 299 | 4.402655 | 13.16393845 | Acytostelium leptosomum | 133408 | Evosea | other_Eukaryota | 449 | 8.440000000000001e-122 | NTclustered | gi|1057487862|gb|KX539491.1| | 133408 | g79012 | i0 | 93.291 | 104.230769230769 | 313 | 7 | 100 | 1 | 1 | 299 | 1398 | 1710 | Acytostelium leptosomum strain FG12A dihydrolipoamide acetyltransferase (pdhC) gene, complete cds | blastn | 31165 | 449 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium leptosomum | ||
| 21338739 | 21338739 | PRJNA951810_P_NODE_180737_length_231_cov_4.031646_g180392_i0 | PRJNA951810 | 180737 | 231 | 4.031646 | 9.31310226 | Ripella tribonemae | 2047823 | Discosea | other_Eukaryota | 390 | 3.849999999999999e-104 | NTclustered | gi|1269228471|gb|MF683596.1| | 2047823 | g180392 | i0 | 96.996 | 101.155844155844 | 233 | 5 | 100 | 2 | 1 | 231 | 1549 | 1317 | Ripella tribonemae clone 22.1.14 18S ribosomal RNA gene, partial sequence | blastn | 23367 | 390 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella tribonemae |
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);;