contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA971676" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 944621 | 944621 | PRJNA971676_P_NODE_1841_length_557_cov_33.832645_g1753_i0 | PRJNA971676 | 1841 | 557 | 33.832645 | 188.44783265 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 863 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g1753 | i0 | 95.118 | 99.6822262118492 | 553 | 18 | 98 | 7 | 11 | 557 | 1 | 550 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 55523 | 863 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 9872833 | 9872833 | PRJNA971676_P_NODE_1908_length_549_cov_2.750000_g1820_i0 | PRJNA971676 | 1908 | 549 | 2.75 | 15.0975 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 370 | 1.3100000000000002e-97 | NTclustered | gi|470441552|ref|XM_004339378.1| | 1257118 | g1820 | i0 | 79.159 | 83.1967213114754 | 547 | 104 | 99 | 8 | 1 | 542 | 3 | 544 | Acanthamoeba castellanii str. Neff ribosomal protein L10, putative (ACA1_061530), partial mRNA | blastn | 45675 | 370 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 13698455 | 13698455 | PRJNA971676_P_NODE_6051_length_345_cov_1.132353_g5962_i0 | PRJNA971676 | 6051 | 345 | 1.132353 | 3.90661785 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 340 | 6.219999999999999e-89 | NTclustered | gi|470439766|ref|XM_004339180.1| | 1257118 | g5962 | i0 | 85.119 | 10.8753623188406 | 336 | 46 | 97 | 4 | 12 | 345 | 1271 | 938 | Acanthamoeba castellanii str. Neff Inositol3-phosphate synthase (ACA1_058810), partial mRNA | blastn | 3752 | 340 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 15294446 | 15294446 | PRJNA971676_P_NODE_2392_length_495_cov_10.672986_g2303_i0 | PRJNA971676 | 2392 | 495 | 10.672986 | 52.8312807 | Vannellidae | 95227 | Discosea | other_Eukaryota | 719 | 0 | NTclustered | gi|327391626|gb|HM363624.1| | 1002216 | g2303 | i0 | 93.214 | 100.678787878788 | 501 | 15 | 100 | 14 | 1 | 495 | 1667 | 1180 | Vannella sp. GERB small subunit ribosomal RNA gene, partial sequence | blastn | 49836 | 723 | 0.994467496542185 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. GERB | |||
| 16247354 | 16247354 | PRJNA971676_P_NODE_1233_length_661_cov_2.619048_g1147_i0 | PRJNA971676 | 1233 | 661 | 2.619048 | 17.31190728 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 486 | 1.5199999999999998e-132 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g1147 | i0 | 80.398 | 92.0680786686838 | 653 | 116 | 98 | 10 | 15 | 661 | 1668 | 2314 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 60857 | 486 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 16247520 | 16247520 | PRJNA971676_P_NODE_2153_length_518_cov_21.539326_g2064_i0 | PRJNA971676 | 2153 | 518 | 21.539326 | 111.57370868 | Ripella decalvata | 2047822 | Discosea | other_Eukaryota | 800 | 0 | NTclustered | gi|1269228437|gb|MF683562.1| | 2047822 | g2064 | i0 | 94.656 | 100.725868725869 | 524 | 14 | 100 | 8 | 1 | 518 | 1044 | 529 | Ripella decalvata clone 15101 18S ribosomal RNA gene, partial sequence | blastn | 52176 | 800 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella decalvata | |||
| 17522906 | 17522906 | PRJNA971676_P_NODE_9474_length_292_cov_1.054795_g9385_i0 | PRJNA971676 | 9474 | 292 | 1.054795 | 3.0800014 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 241 | 5.38e-59 | NTclustered | gi|831769224|ref|XM_012897186.1| | 1410327 | g9385 | i0 | 82.784 | 9.37671232876712 | 273 | 43 | 93 | 4 | 4 | 274 | 564 | 294 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 2738 | 241 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 23897225 | 23897225 | PRJNA971676_P_NODE_3919_length_405_cov_1.177711_g3830_i0 | PRJNA971676 | 3919 | 405 | 1.177711 | 4.76972955 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 198 | 4.72e-46 | NTclustered | gi|66801350|ref|XM_629599.1| | 352472 | g3830 | i0 | 83.333 | 25.8246913580247 | 216 | 34 | 53 | 2 | 186 | 400 | 215 | 1 | Dictyostelium discoideum AX4 S60 ribosomal protein L27a (rpl27a) mRNA, complete cds | blastn | 10459 | 198 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 23897256 | 23897256 | PRJNA971676_P_NODE_5679_length_353_cov_0.967857_g5590_i0 | PRJNA971676 | 5679 | 353 | 0.967857 | 3.41653521 | Telaepolella tubasferens | 1346289 | Evosea | other_Eukaryota | 322 | 2.3e-83 | NTclustered | gi|167859713|gb|EU273436.1| | 1346289 | g5590 | i0 | 83.239 | 92.1274787535411 | 352 | 57 | 99 | 2 | 1 | 351 | 497 | 147 | Telaepolella tubasferens clone 2 actin gene, partial cds | blastn | 32521 | 322 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Telaepolella | Telaepolella tubasferens |
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);;