contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA784979" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2488895 | 2488895 | PRJNA784979_S_NODE_5222_length_211_cov_4.351852_g5180_i0 | PRJNA784979 | 5222 | 211 | 4.351852 | 9.18240772 | Vannella | 95228 | Discosea | other_Eukaryota | 307 | 3.5800000000000004e-79 | NTclustered | gi|399764226|gb|JQ271737.1| | 1215641 | g5180 | i0 | 95.408 | 91.6208530805687 | 196 | 3 | 91 | 5 | 6 | 196 | 1314 | 1120 | Vannella sp. ELH6 18S ribosomal RNA gene, partial sequence | blastn | 19332 | 309 | 0.993527508090615 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. ELH6 | |||
| 2488924 | 2488924 | PRJNA784979_S_NODE_8962_length_174_cov_2.256000_g8920_i0 | PRJNA784979 | 8962 | 174 | 2.256 | 3.92544 | Protostelium | 472930 | Evosea | other_Eukaryota | 313 | 6.079999999999998e-81 | NTclustered | gi|262262921|gb|FJ766464.1| | 472931 | g8920 | i0 | 99.422 | 361.64367816092 | 173 | 0 | 99 | 1 | 1 | 173 | 1331 | 1502 | Protostelium mycophagum strain KA-T15-2 small subunit ribosomal RNA gene, partial sequence | blastn | 62926 | 313 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 8418671 | 8418671 | PRJNA784979_S_NODE_3747_length_240_cov_3.219895_g3705_i0 | PRJNA784979 | 3747 | 240 | 3.219895 | 7.727748 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 134 | 7.49e-27 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g3705 | i0 | 84.211 | 7.58333333333333 | 133 | 18 | 55 | 3 | 44 | 174 | 4224 | 4355 | Vannella septentrionalis 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 | 1820 | 134 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 8418707 | 8418707 | PRJNA784979_S_NODE_967_length_548_cov_7.092184_g925_i0 | PRJNA784979 | 967 | 548 | 7.092184 | 38.86516832 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 501 | 4.45e-137 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g925 | i0 | 83.544 | 66.1058394160584 | 553 | 73 | 99 | 17 | 1 | 542 | 862 | 1407 | Vannella septentrionalis 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 | 36226 | 501 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 10969645 | 10969645 | PRJNA784979_S_NODE_1229_length_458_cov_11.107579_g1187_i0 | PRJNA784979 | 1229 | 458 | 11.107579 | 50.87271182 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 595 | 1.6399999999999994e-165 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g1187 | i0 | 90.889 | 59.2205240174672 | 450 | 31 | 97 | 5 | 13 | 456 | 2867 | 2422 | Vannella septentrionalis 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 | 27123 | 595 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 10969687 | 10969687 | PRJNA784979_S_NODE_7669_length_184_cov_5.637037_g7627_i0 | PRJNA784979 | 7669 | 184 | 5.637037 | 10.37214808 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 250 | 5.18e-62 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g7627 | i0 | 92.655 | 46.9021739130435 | 177 | 8 | 94 | 5 | 12 | 184 | 3457 | 3632 | Vannella septentrionalis 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 | 8630 | 250 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 12245125 | 12245125 | PRJNA784979_S_NODE_2450_length_293_cov_4.868852_g2408_i0 | PRJNA784979 | 2450 | 293 | 4.868852 | 14.26573636 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 399 | 8.419999999999998e-107 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g2408 | i0 | 92.553 | 56.2491467576792 | 282 | 16 | 96 | 3 | 10 | 290 | 1627 | 1904 | Vannella septentrionalis 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 | 16481 | 399 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 13519333 | 13519333 | PRJNA784979_S_NODE_1791_length_353_cov_7.131579_g1749_i0 | PRJNA784979 | 1791 | 353 | 7.131579 | 25.17447387 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 381 | 3.749999999999999e-101 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g1749 | i0 | 88.199 | 45.1416430594901 | 322 | 34 | 91 | 3 | 8 | 327 | 3147 | 2828 | Vannella septentrionalis 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 | 15935 | 381 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 16068057 | 16068057 | PRJNA784979_S_NODE_2953_length_268_cov_4.319635_g2911_i0 | PRJNA784979 | 2953 | 268 | 4.319635 | 11.5766218 | Vannella sp. T02 | 1215673 | Discosea | other_Eukaryota | 377 | 3.56e-100 | NTclustered | gi|399764258|gb|JQ271769.1| | 1215673 | g2911 | i0 | 97.727 | 82.6679104477612 | 220 | 4 | 82 | 1 | 7 | 226 | 1813 | 1595 | Vannella sp. T02 18S ribosomal RNA gene, partial sequence | blastn | 22155 | 377 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. T02 | |||
| 17343804 | 17343804 | PRJNA784979_S_NODE_7434_length_186_cov_13.423358_g7392_i0 | PRJNA784979 | 7434 | 186 | 13.423358 | 24.96744588 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 279 | 6.7000000000000014e-71 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g7392 | i0 | 94.972 | 96.6720430107527 | 179 | 7 | 95 | 2 | 3 | 179 | 2261 | 2439 | Vannella septentrionalis 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 | 17981 | 279 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 18617087 | 18617087 | PRJNA784979_S_NODE_13655_length_158_cov_10.614679_g13613_i0 | PRJNA784979 | 13655 | 158 | 10.614679 | 16.77119282 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 265 | 1.5399999999999998e-66 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g13613 | i0 | 100 | 91.6708860759494 | 143 | 0 | 91 | 0 | 7 | 149 | 3623 | 3765 | Vannella septentrionalis 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 | 14484 | 265 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 19065139 | 19065139 | PRJNA784979_S_NODE_9455_length_171_cov_2.122951_g9413_i0 | PRJNA784979 | 9455 | 171 | 2.122951 | 3.63024621 | Protostelium | 472930 | Evosea | other_Eukaryota | 296 | 5.99e-76 | NTclustered | gi|262262921|gb|FJ766464.1| | 472931 | g9413 | i0 | 98.802 | 6.55555555555556 | 167 | 0 | 98 | 1 | 1 | 167 | 833 | 669 | Protostelium mycophagum strain KA-T15-2 small subunit ribosomal RNA gene, partial sequence | blastn | 1121 | 296 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 21168048 | 21168048 | PRJNA784979_S_NODE_1057_length_515_cov_5.693133_g1015_i0 | PRJNA784979 | 1057 | 515 | 5.6931330000000004 | 29.31963495 | Vannella sp. LITHOV | 1215650 | Discosea | other_Eukaryota | 808 | 0 | NTclustered | gi|399764235|gb|JQ271746.1| | 1215650 | g1015 | i0 | 96.728 | 93.3087378640777 | 489 | 9 | 94 | 5 | 23 | 508 | 15 | 499 | Vannella sp. LITHOV 18S ribosomal RNA gene, partial sequence | blastn | 48054 | 808 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. LITHOV | |||
| 21615576 | 21615576 | PRJNA784979_S_NODE_13857_length_155_cov_3.056604_g13815_i0 | PRJNA784979 | 13857 | 155 | 3.056604 | 4.7377362 | Vannella | 95228 | Discosea | other_Eukaryota | 255 | 9.05e-64 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g13815 | i0 | 97.351 | 96.7290322580645 | 151 | 3 | 97 | 1 | 5 | 155 | 550 | 401 | Vannella septentrionalis 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 | 14993 | 255 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 23718369 | 23718369 | PRJNA784979_S_NODE_1439_length_402_cov_6.288952_g1397_i0 | PRJNA784979 | 1439 | 402 | 6.288952 | 25.28158704 | Vannella sp. ELH6 | 1215641 | Discosea | other_Eukaryota | 492 | 1.92e-134 | NTclustered | gi|399764226|gb|JQ271737.1| | 1215641 | g1397 | i0 | 91.16 | 71.9800995024876 | 362 | 32 | 90 | 0 | 35 | 396 | 739 | 1100 | Vannella sp. ELH6 18S ribosomal RNA gene, partial sequence | blastn | 28936 | 492 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. ELH6 | |||
| 23718384 | 23718384 | PRJNA784979_S_NODE_4259_length_228_cov_1.843575_g4217_i0 | PRJNA784979 | 4259 | 228 | 1.843575 | 4.203351 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 316 | 6.53e-82 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g4217 | i0 | 97.826 | 77.7456140350877 | 184 | 3 | 80 | 1 | 7 | 189 | 2105 | 1922 | Vannella septentrionalis 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 | 17726 | 316 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 24164954 | 24164954 | PRJNA784979_S_NODE_10079_length_167_cov_2.906780_g10037_i0 | PRJNA784979 | 10079 | 167 | 2.90678 | 4.8543226 | Vannella | 95228 | Discosea | other_Eukaryota | 252 | 1.29e-62 | NTclustered | gi|2326458234|gb|OP791903.1| | 207334 | g10037 | i0 | 95.062 | 96.2874251497006 | 162 | 5 | 95 | 3 | 9 | 167 | 1510 | 1349 | Vannella ebro clone A616.1 small subunit ribosomal RNA gene, partial sequence | blastn | 16080 | 252 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella ebro |
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);;