contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA688931" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 668450 | 668450 | PRJNA688931_P_NODE_20141_length_228_cov_1.413408_g19928_i0 | PRJNA688931 | 20141 | 228 | 1.413408 | 3.22257024 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 176 | 1.16e-39 | NTclustered | gi|470241101|ref|XM_004352074.1| | 261658 | g19928 | i0 | 87.919 | 70.2456140350877 | 149 | 18 | 65 | 0 | 80 | 228 | 2483 | 2335 | Cavenderia fasciculata RNA polymerase II largest subunit (rpb1), partial mRNA | blastn | 16016 | 176 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 3219353 | 3219353 | PRJNA688931_P_NODE_28723_length_190_cov_1.092199_g28510_i0 | PRJNA688931 | 28723 | 190 | 1.092199 | 2.0751781 | Spumochlamys bryora | 675832 | Tubulinea | other_Eukaryota | 346 | 6.690000000000001e-91 | NTclustered | gi|259595677|gb|FJ705341.1| | 675832 | g28510 | i0 | 99.474 | 6.02631578947368 | 190 | 1 | 100 | 0 | 1 | 190 | 993 | 1182 | Spumochlamys bryora clone 1901 18S ribosomal RNA gene, partial sequence | blastn | 1145 | 346 | 1 | Eukaryota | Amoebozoa | Tubulinea | Corycida | Microchlamyiidae | Spumochlamys | Spumochlamys bryora | |||
| 7047149 | 7047149 | PRJNA688931_P_NODE_32946_length_175_cov_2.214286_g32733_i0 | PRJNA688931 | 32946 | 175 | 2.214286 | 3.8750005 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 115 | 1.85e-21 | NTclustered | gi|831756695|ref|XM_012893348.1| | 1410327 | g32733 | i0 | 80.667 | 0.857142857142857 | 150 | 27 | 85 | 2 | 3 | 151 | 182 | 34 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 150 | 115 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 8321685 | 8321685 | PRJNA688931_P_NODE_34767_length_170_cov_1.272727_g34554_i0 | PRJNA688931 | 34767 | 170 | 1.272727 | 2.1636359 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 84.2 | 5.04e-12 | NTclustered | gi|831776054|ref|XM_012899232.1| | 1410327 | g34554 | i0 | 82.796 | 0.729411764705882 | 93 | 16 | 55 | 0 | 10 | 102 | 1161 | 1253 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 124 | 84.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 10872573 | 10872573 | PRJNA688931_P_NODE_30249_length_184_cov_1.903704_g30036_i0 | PRJNA688931 | 30249 | 184 | 1.903704 | 3.50281536 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 156 | 1.16e-33 | NTclustered | gi|470439766|ref|XM_004339180.1| | 1257118 | g30036 | i0 | 83.529 | 6.34782608695652 | 170 | 24 | 91 | 3 | 17 | 184 | 1052 | 885 | Acanthamoeba castellanii str. Neff Inositol3-phosphate synthase (ACA1_058810), partial mRNA | blastn | 1168 | 156 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 12147734 | 12147734 | PRJNA688931_P_NODE_15890_length_258_cov_1.923445_g15677_i0 | PRJNA688931 | 15890 | 258 | 1.923445 | 4.9624881 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 128 | 3.79e-25 | NTclustered | gi|831792076|ref|XM_012904471.1| | 1410327 | g15677 | i0 | 86.066 | 0.89922480620155 | 122 | 13 | 47 | 2 | 1 | 120 | 1524 | 1643 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 232 | 128 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 13422587 | 13422587 | PRJNA688931_P_NODE_9531_length_344_cov_1.525424_g9318_i0 | PRJNA688931 | 9531 | 344 | 1.525424 | 5.24745856 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 303 | 8.14e-78 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g9318 | i0 | 82.899 | 49.9011627906977 | 345 | 51 | 99 | 6 | 2 | 342 | 2384 | 2044 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 17166 | 303 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 15971213 | 15971213 | PRJNA688931_P_NODE_27493_length_194_cov_1.779310_g27280_i0 | PRJNA688931 | 27493 | 194 | 1.77931 | 3.4518614 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|1160560456|ref|XM_020578332.1| | 670386 | g27280 | i0 | 96.875 | 0.164948453608247 | 32 | 1 | 16 | 0 | 78 | 109 | 1361 | 1330 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 17246490 | 17246490 | PRJNA688931_P_NODE_40354_length_164_cov_1.721739_g40141_i0 | PRJNA688931 | 40354 | 164 | 1.721739 | 2.82365196 | Ripella platypodia | 2047821 | Discosea | other_Eukaryota | 259 | 7.52e-65 | NTclustered | gi|1269228348|gb|MF683473.1| | 2047821 | g40141 | i0 | 95.181 | 101.640243902439 | 166 | 4 | 100 | 3 | 1 | 164 | 1307 | 1144 | Ripella platypodia clone 21702 18S ribosomal RNA gene, partial sequence | blastn | 16669 | 259 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella platypodia | |||
| 18520501 | 18520501 | PRJNA688931_P_NODE_19555_length_231_cov_3.021978_g19342_i0 | PRJNA688931 | 19555 | 231 | 3.021978 | 6.98076918 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 115 | 2.6e-21 | NTclustered | gi|470529917|ref|XM_004368096.1| | 1257118 | g19342 | i0 | 89.13 | 38.8614718614719 | 92 | 10 | 40 | 0 | 2 | 93 | 212 | 121 | Acanthamoeba castellanii str. Neff ribosomal protein S17, putative (ACA1_292890), partial mRNA | blastn | 8977 | 115 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 18520509 | 18520509 | PRJNA688931_P_NODE_2155_length_774_cov_3.936552_g1995_i0 | PRJNA688931 | 2155 | 774 | 3.936552 | 30.46891248 | Ripella sp. GP2 | 1217115 | Discosea | other_Eukaryota | 846 | 0 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g1995 | i0 | 93.448 | 72.4896640826873 | 580 | 23 | 74 | 11 | 200 | 774 | 1 | 570 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 56107 | 846 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 19795298 | 19795298 | PRJNA688931_P_NODE_12956_length_289_cov_1.466667_g12743_i0 | PRJNA688931 | 12956 | 289 | 1.466667 | 4.23866763 | Ripella sp. GP2 | 1217115 | Discosea | other_Eukaryota | 440 | 4.889999999999998e-119 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g12743 | i0 | 97.308 | 79.6643598615917 | 260 | 5 | 90 | 1 | 1 | 260 | 675 | 932 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 23023 | 440 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 19795383 | 19795383 | PRJNA688931_P_NODE_23696_length_210_cov_1.354037_g23483_i0 | PRJNA688931 | 23696 | 210 | 1.354037 | 2.8434777 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 215 | 2.22e-51 | NTclustered | gi|470484553|ref|XM_004344028.1| | 1257118 | g23483 | i0 | 88.268 | 84.3 | 179 | 21 | 85 | 0 | 32 | 210 | 362 | 184 | Acanthamoeba castellanii str. Neff Sadenosyl-L-homocysteine hydrolase, putative (ACA1_054200), partial mRNA | blastn | 17703 | 215 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 24894749 | 24894749 | PRJNA688931_P_NODE_35600_length_168_cov_1.949580_g35387_i0 | PRJNA688931 | 35600 | 168 | 1.94958 | 3.2752944 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 58.4 | 3.03e-4 | NTclustered | gi|470492282|ref|XM_004345943.1| | 1257118 | g35387 | i0 | 100 | 0.351190476190476 | 31 | 0 | 18 | 0 | 37 | 67 | 721 | 691 | Acanthamoeba castellanii str. Neff uncharacterized protein (ACA1_183950), partial mRNA | blastn | 59 | 58.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 24894859 | 24894859 | PRJNA688931_P_NODE_6380_length_433_cov_2.067708_g6167_i0 | PRJNA688931 | 6380 | 433 | 2.067708 | 8.95317564 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 54.7 | 0.012 | NTclustered | gi|831783851|ref|XM_012901808.1| | 1410327 | g6167 | i0 | 96.875 | 0.0739030023094688 | 32 | 1 | 7 | 0 | 257 | 288 | 146 | 115 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum |
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);;