contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA498309" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 482711 | 482711 | PRJNA498309_S_NODE_9841_length_812_cov_15.500644_g8096_i0 | PRJNA498309 | 9841 | 812 | 15.500644 | 125.86522928 | Acytostelium leptosomum | 133408 | Evosea | other_Eukaryota | 1225 | 0 | NTclustered | gi|1057487862|gb|KX539491.1| | 133408 | g8096 | i0 | 94.472 | 98.1945812807882 | 796 | 42 | 98 | 2 | 18 | 812 | 1031 | 1825 | Acytostelium leptosomum strain FG12A dihydrolipoamide acetyltransferase (pdhC) gene, complete cds | blastn | 79734 | 1225 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium leptosomum | ||
| 5585708 | 5585708 | PRJNA498309_S_NODE_24065_length_383_cov_13.681034_g21901_i0 | PRJNA498309 | 24065 | 383 | 13.681034 | 52.39836022 | Arcyria cinerea | 137621 | Evosea | other_Eukaryota | 117 | 1.28e-21 | NTclustered | gi|2753773268|gb|PP982846.1| | 137621 | g21901 | i0 | 73.713 | 13.8041775456919 | 369 | 68 | 93 | 24 | 1 | 355 | 2589 | 2236 | Arcyria cinerea voucher MEL2416382 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 5287 | 117 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Arcyria | Arcyria cinerea | ||
| 6858705 | 6858705 | PRJNA498309_P_NODE_58246_length_335_cov_5.697987_g56098_i0 | PRJNA498309 | 58246 | 335 | 5.697987 | 19.08825645 | Acytostelium leptosomum | 133408 | Evosea | other_Eukaryota | 512 | 1.21e-140 | NTclustered | gi|1057487862|gb|KX539491.1| | 133408 | g56098 | i0 | 97.351 | 85.9641791044776 | 302 | 7 | 90 | 1 | 4 | 304 | 97 | 398 | Acytostelium leptosomum strain FG12A dihydrolipoamide acetyltransferase (pdhC) gene, complete cds | blastn | 28798 | 512 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium leptosomum | ||
| 6859550 | 6859550 | PRJNA498309_S_NODE_16826_length_535_cov_2.936000_g14805_i0 | PRJNA498309 | 16826 | 535 | 2.936 | 15.7076 | Acytostelium leptosomum | 133408 | Evosea | other_Eukaryota | 737 | 0 | NTclustered | gi|1057487862|gb|KX539491.1| | 133408 | g14805 | i0 | 93.548 | 2.09345794392523 | 496 | 31 | 93 | 1 | 17 | 511 | 3313 | 3808 | Acytostelium leptosomum strain FG12A dihydrolipoamide acetyltransferase (pdhC) gene, complete cds | blastn | 1120 | 737 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium leptosomum | ||
| 8134357 | 8134357 | PRJNA498309_P_NODE_73427_length_273_cov_2.224576_g71278_i0 | PRJNA498309 | 73427 | 273 | 2.224576 | 6.07309248 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 209 | 1.41e-49 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g71278 | i0 | 80.887 | 16.5934065934066 | 293 | 33 | 99 | 16 | 1 | 271 | 6465 | 6174 | Acanthamoeba castellanii 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 | 4530 | 209 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 9410278 | 9410278 | PRJNA498309_S_NODE_30388_length_296_cov_5.000000_g28220_i0 | PRJNA498309 | 30388 | 296 | 5 | 14.8 | Licea marginata | 1334548 | Evosea | other_Eukaryota | 154 | 7.32e-33 | NTclustered | gi|501417082|gb|JX481296.1| | 1334548 | g28220 | i0 | 87.786 | 39.4087837837838 | 131 | 16 | 44 | 0 | 23 | 153 | 495 | 365 | Licea marginata voucher DWM7368 18S ribosomal RNA gene, partial sequence | blastn | 11665 | 154 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Liceales | Liceaceae | Licea | Licea marginata | ||
| 11958836 | 11958836 | PRJNA498309_P_NODE_110430_length_172_cov_1.414815_g108281_i0 | PRJNA498309 | 110430 | 172 | 1.414815 | 2.4334818 | Amoebozoa sp. | 1892891 | Root_unresolved | Root_unresolved | 261 | 2.2000000000000002e-65 | NTclustered | gi|2651357789|gb|PP174304.1| | 1892891 | g108281 | i0 | 99.306 | 79.1453488372093 | 144 | 1 | 84 | 0 | 29 | 172 | 3443 | 3300 | Amoebozoa sp. isolate 114_WLI 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 | 13613 | 261 | 1 | Eukaryota | Amoebozoa | Amoebozoa sp. | |||||||
| 11961483 | 11961483 | PRJNA498309_S_NODE_8250_length_922_cov_10.837655_g6610_i0 | PRJNA498309 | 8250 | 922 | 10.837655 | 99.9231791 | Acytostelium leptosomum | 133408 | Evosea | other_Eukaryota | 1330 | 0 | NTclustered | gi|1057487862|gb|KX539491.1| | 133408 | g6610 | i0 | 93.459 | 100.375271149675 | 902 | 49 | 98 | 7 | 1 | 900 | 1773 | 2666 | Acytostelium leptosomum strain FG12A dihydrolipoamide acetyltransferase (pdhC) gene, complete cds | blastn | 92546 | 1330 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium leptosomum | ||
| 15783621 | 15783621 | PRJNA498309_P_NODE_54473_length_353_cov_4.756329_g52325_i0 | PRJNA498309 | 54473 | 353 | 4.756329 | 16.78984137 | Didymium iridis | 5793 | Evosea | other_Eukaryota | 351 | 2.94e-92 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g52325 | i0 | 86.687 | 1.13031161473088 | 323 | 35 | 90 | 8 | 17 | 332 | 5541 | 5220 | D.iridis LSU rRNA gene | blastn | 399 | 351 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 20884194 | 20884194 | PRJNA498309_S_NODE_29857_length_302_cov_13.314607_g27689_i0 | PRJNA498309 | 29857 | 302 | 13.314607 | 40.21011314 | Paramoeba pemaquidensis | 180228 | Discosea | other_Eukaryota | 187 | 7.39e-43 | NTclustered | gi|145386790|gb|EF216915.1| | 180228 | g27689 | i0 | 78.846 | 65.364238410596 | 312 | 41 | 100 | 20 | 1 | 302 | 333 | 37 | Paramoeba pemaquidensis strain PA027 28S large subunit ribosomal RNA gene, partial sequence | blastn | 19740 | 187 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba pemaquidensis | ||
| 20884401 | 20884401 | PRJNA498309_S_NODE_39917_length_214_cov_1.486034_g37749_i0 | PRJNA498309 | 39917 | 214 | 1.486034 | 3.18011276 | Macbrideola oblonga | 410620 | Evosea | other_Eukaryota | 167 | 6.449999999999999e-37 | NTclustered | gi|118577476|gb|DQ903682.1| | 410620 | g37749 | i0 | 91.057 | 58.2570093457944 | 123 | 11 | 57 | 0 | 92 | 214 | 1537 | 1659 | Macbrideola oblonga voucher M. Schnittler small subunit ribosomal RNA gene, partial sequence | blastn | 12467 | 167 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Macbrideola | Macbrideola oblonga | |||
| 23432516 | 23432516 | PRJNA498309_P_NODE_112419_length_168_cov_1.740458_g110270_i0 | PRJNA498309 | 112419 | 168 | 1.740458 | 2.92396944 | Amoebozoa sp. | 1892891 | Root_unresolved | Root_unresolved | 283 | 4.6e-72 | NTclustered | gi|2651357789|gb|PP174304.1| | 1892891 | g110270 | i0 | 97.024 | 9.52976190476191 | 168 | 5 | 100 | 0 | 1 | 168 | 3851 | 4018 | Amoebozoa sp. isolate 114_WLI 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 | 1601 | 283 | 1 | Eukaryota | Amoebozoa | Amoebozoa sp. |
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);;