contig_metadata
15 rows where bioproject = "PRJNA407368" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10619040 | 10619040 | PRJNA407368_S_NODE_4909_length_252_cov_4.995516_g4807_i0 | PRJNA407368 | 4909 | 252 | 4.995516 | 12.58870032 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 416 | 7.029999999999999e-112 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g4807 | i0 | 96.429 | 31.781746031746 | 252 | 9 | 100 | 0 | 1 | 252 | 1408 | 1157 | 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 | 8009 | 416 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 10619044 | 10619044 | PRJNA407368_S_NODE_5129_length_244_cov_17.567442_g5027_i0 | PRJNA407368 | 5129 | 244 | 17.567442 | 42.86455848 | Stenamoeba amazonica | 746910 | Discosea | other_Eukaryota | 431 | 2.419999999999999e-116 | NTclustered | gi|292399456|gb|GU810184.1| | 746910 | g5027 | i0 | 100 | 39.9180327868852 | 233 | 0 | 95 | 0 | 1 | 233 | 1630 | 1862 | Stenamoeba amazonica strain P119 small subunit ribosomal RNA gene, partial sequence | blastn | 9740 | 431 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Stenamoeba | Stenamoeba amazonica | |||
| 11893954 | 11893954 | PRJNA407368_S_NODE_5690_length_227_cov_11.525253_g5588_i0 | PRJNA407368 | 5690 | 227 | 11.525253 | 26.16232431 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 364 | 2.289999999999999e-96 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g5588 | i0 | 95.595 | 27.3700440528634 | 227 | 10 | 100 | 0 | 1 | 227 | 877 | 1103 | 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 | 6213 | 364 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 11893964 | 11893964 | PRJNA407368_S_NODE_6170_length_216_cov_4.962567_g6068_i0 | PRJNA407368 | 6170 | 216 | 4.962567 | 10.71914472 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 318 | 1.7e-82 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g6068 | i0 | 93.868 | 20.8240740740741 | 212 | 12 | 98 | 1 | 5 | 216 | 4340 | 4130 | 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 | 4498 | 318 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 13168780 | 13168780 | PRJNA407368_S_NODE_1471_length_523_cov_31.779352_g1378_i0 | PRJNA407368 | 1471 | 523 | 31.779352 | 166.20601096 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 845 | 0 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g1378 | i0 | 95.985 | 42.623326959847 | 523 | 16 | 99 | 3 | 5 | 523 | 2954 | 2433 | 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 | 22292 | 845 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 14444033 | 14444033 | PRJNA407368_S_NODE_5412_length_235_cov_46.330097_g5310_i0 | PRJNA407368 | 5412 | 235 | 46.330097 | 108.87572795 | Vannella sp. ACN1 | 1215628 | Discosea | other_Eukaryota | 424 | 3.87e-114 | NTclustered | gi|399764213|gb|JQ271724.1| | 1215628 | g5310 | i0 | 99.149 | 92.0468085106383 | 235 | 2 | 100 | 0 | 1 | 235 | 371 | 137 | Vannella sp. ACN1 18S ribosomal RNA gene, partial sequence | blastn | 21631 | 424 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. ACN1 | |||
| 16992713 | 16992713 | PRJNA407368_S_NODE_8954_length_169_cov_2.042857_g8852_i0 | PRJNA407368 | 8954 | 169 | 2.042857 | 3.45242833 | Stenamoeba amazonica | 746910 | Discosea | other_Eukaryota | 278 | 2.14e-70 | NTclustered | gi|292399456|gb|GU810184.1| | 746910 | g8852 | i0 | 96.491 | 8.02366863905325 | 171 | 1 | 100 | 4 | 1 | 169 | 1067 | 900 | Stenamoeba amazonica strain P119 small subunit ribosomal RNA gene, partial sequence | blastn | 1356 | 278 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Stenamoeba | Stenamoeba amazonica | |||
| 16992728 | 16992728 | PRJNA407368_S_NODE_9694_length_159_cov_18.430769_g9592_i0 | PRJNA407368 | 9694 | 159 | 18.430769 | 29.30492271 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 289 | 9.22e-74 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g9592 | i0 | 99.371 | 100.672955974843 | 159 | 1 | 100 | 0 | 1 | 159 | 2278 | 2436 | 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 | 16007 | 289 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 18266710 | 18266710 | PRJNA407368_S_NODE_5535_length_231_cov_13.445545_g5433_i0 | PRJNA407368 | 5535 | 231 | 13.445545 | 31.05920895 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 394 | 2.98e-105 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g5433 | i0 | 97.403 | 25.6060606060606 | 231 | 6 | 100 | 0 | 1 | 231 | 3144 | 2914 | 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 | 5915 | 394 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 18266746 | 18266746 | PRJNA407368_S_NODE_6895_length_200_cov_15.818713_g6793_i0 | PRJNA407368 | 6895 | 200 | 15.818713 | 31.637426 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 359 | 9.14e-95 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g6793 | i0 | 99 | 62.3 | 200 | 2 | 100 | 0 | 1 | 200 | 3431 | 3630 | 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 | 12460 | 359 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 20816833 | 20816833 | PRJNA407368_S_NODE_8997_length_168_cov_3.323741_g8895_i0 | PRJNA407368 | 8997 | 168 | 3.323741 | 5.58388488 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 278 | 2.14e-70 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g8895 | i0 | 96.429 | 1 | 168 | 6 | 100 | 0 | 1 | 168 | 1549 | 1382 | 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 | 168 | 278 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 23367110 | 23367110 | PRJNA407368_S_NODE_1559_length_504_cov_120.372632_g1465_i0 | PRJNA407368 | 1559 | 504 | 120.372632 | 606.67806528 | Stenamoeba amazonica | 746910 | Discosea | other_Eukaryota | 510 | 6.7599999999999995e-140 | NTclustered | gi|292399456|gb|GU810184.1| | 746910 | g1465 | i0 | 95.886 | 40.3075396825397 | 316 | 12 | 63 | 1 | 173 | 487 | 1796 | 2111 | Stenamoeba amazonica strain P119 small subunit ribosomal RNA gene, partial sequence | blastn | 20315 | 510 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Stenamoeba | Stenamoeba amazonica | |||
| 23367268 | 23367268 | PRJNA407368_S_NODE_9719_length_159_cov_3.738462_g9617_i0 | PRJNA407368 | 9719 | 159 | 3.738462 | 5.94415458 | Stenamoeba amazonica | 746910 | Discosea | other_Eukaryota | 294 | 1.98e-75 | NTclustered | gi|292399456|gb|GU810184.1| | 746910 | g9617 | i0 | 100 | 99.8993710691824 | 159 | 0 | 100 | 0 | 1 | 159 | 1210 | 1052 | Stenamoeba amazonica strain P119 small subunit ribosomal RNA gene, partial sequence | blastn | 15884 | 294 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Stenamoeba | Stenamoeba amazonica | |||
| 27802127 | 27802127 | PRJNA407368_S_NODE_9564_length_161_cov_2.863636_g9462_i0 | PRJNA407368 | 9564 | 161 | 2.863636 | 4.61045396 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 49.3 | 5.82e-5 | NR | XP_004336616.1 | 1257118 | g9462 | i0 | 68.8 | 1.15527950310559 | 32 | 10 | 59.6 | 0 | 106 | 11 | 7 | 38 | XP_004336616.1 ribosomal protein L10, putative [Acanthamoeba castellanii str. Neff] | diamond | 186 | 49.3 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31750454 | 31750454 | PRJNA407368_S_NODE_7557_length_188_cov_3.150943_g7455_i0 | PRJNA407368 | 7557 | 188 | 3.150943 | 5.92377284 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 82.4 | 1.87e-16 | NR | XP_004356787.1 | 1257118 | g7455 | i0 | 60.6 | 1.0531914893617 | 66 | 22 | 98.9 | 1 | 188 | 3 | 518 | 583 | XP_004356787.1 IQGAPrelated protein [Acanthamoeba castellanii str. Neff] | diamond | 198 | 82.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;