contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA760976" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2018323 | 2018323 | PRJNA760976_P_NODE_13282_length_402_cov_5.018237_g12962_i0 | PRJNA760976 | 13282 | 402 | 5.018237 | 20.17331274 | Vannella ebro | 207334 | Discosea | other_Eukaryota | 531 | 4.06e-146 | NTclustered | gi|33946344|gb|AY294151.1| | 207334 | g12962 | i0 | 91.26 | 97.5422885572139 | 389 | 34 | 97 | 0 | 1 | 389 | 401 | 13 | Vannella ebro actin mRNA, complete cds | blastn | 39212 | 531 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella ebro | |||
| 8395601 | 8395601 | PRJNA760976_P_NODE_17987_length_361_cov_2.569444_g17666_i0 | PRJNA760976 | 17987 | 361 | 2.569444 | 9.27569284 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 484 | 2.8499999999999995e-132 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g17666 | i0 | 90.859 | 100.396121883657 | 361 | 33 | 100 | 0 | 1 | 361 | 872 | 512 | Platyamoeba placida actin mRNA, partial cds | blastn | 36243 | 484 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 10946492 | 10946492 | PRJNA760976_P_NODE_48689_length_249_cov_4.772727_g48368_i0 | PRJNA760976 | 48689 | 249 | 4.772727 | 11.88409023 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 350 | 7.14e-92 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g48368 | i0 | 91.968 | 99.566265060241 | 249 | 20 | 100 | 0 | 1 | 249 | 708 | 956 | Platyamoeba placida actin mRNA, partial cds | blastn | 24792 | 350 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 10946503 | 10946503 | PRJNA760976_P_NODE_5129_length_586_cov_4.879142_g4818_i0 | PRJNA760976 | 5129 | 586 | 4.879142 | 28.59177212 | Vannella persistens | 303303 | Discosea | other_Eukaryota | 950 | 0 | NTclustered | gi|165968548|gb|EU377588.1| | 303303 | g4818 | i0 | 95.911 | 87.1245733788396 | 587 | 23 | 100 | 1 | 1 | 586 | 130 | 716 | Vannella persistens strain CRIB69 18S ribosomal RNA gene, partial sequence | blastn | 51055 | 950 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella persistens | |||
| 12221969 | 12221969 | PRJNA760976_P_NODE_19390_length_352_cov_4.878136_g19069_i0 | PRJNA760976 | 19390 | 352 | 4.878136 | 17.17103872 | Ripella decalvata | 2047822 | Discosea | other_Eukaryota | 562 | 1.2399999999999997e-155 | NTclustered | gi|1269228416|gb|MF683541.1| | 2047822 | g19069 | i0 | 95.751 | 99.9659090909091 | 353 | 8 | 99 | 6 | 2 | 352 | 899 | 552 | Ripella decalvata clone 26.1.53 18S ribosomal RNA gene, partial sequence | blastn | 35188 | 562 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella decalvata | |||
| 12222025 | 12222025 | PRJNA760976_P_NODE_3930_length_659_cov_1.674061_g3624_i0 | PRJNA760976 | 3930 | 659 | 1.674061 | 11.03206199 | Paramoeba pemaquidensis | 180228 | Discosea | other_Eukaryota | 536 | 1.49e-147 | NTclustered | gi|1079488025|ref|NC_031417.1| | 180228 | g3624 | i0 | 81.818 | 40.4355083459788 | 671 | 92 | 99 | 21 | 1 | 658 | 32298 | 32951 | Paramoeba pemaquidensis culture-collection CCAP:1560/4 mitochondrion, complete genome | blastn | 26647 | 536 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba pemaquidensis | ||
| 13496128 | 13496128 | PRJNA760976_P_NODE_3431_length_703_cov_4.644444_g3129_i0 | PRJNA760976 | 3431 | 703 | 4.644444 | 32.65044132 | Paramoeba pemaquidensis | 180228 | Discosea | other_Eukaryota | 228 | 1.0899999999999999e-54 | NTclustered | gi|1079488025|ref|NC_031417.1| | 180228 | g3129 | i0 | 74.179 | 32.7809388335704 | 670 | 118 | 93 | 40 | 4 | 656 | 31907 | 32538 | Paramoeba pemaquidensis culture-collection CCAP:1560/4 mitochondrion, complete genome | blastn | 23045 | 228 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba pemaquidensis | ||
| 14771230 | 14771230 | PRJNA760976_P_NODE_17672_length_364_cov_1.058419_g17351_i0 | PRJNA760976 | 17672 | 364 | 1.058419 | 3.85264516 | Cochliopodium spiniferum | 313558 | Discosea | other_Eukaryota | 348 | 3.93e-91 | NTclustered | gi|330902904|gb|JF298276.1| | 313558 | g17351 | i0 | 84.123 | 100.164835164835 | 359 | 57 | 99 | 0 | 5 | 363 | 413 | 55 | Cochliopodium spiniferum clone 5105 actin gene, partial cds | blastn | 36460 | 348 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium spiniferum | |||
| 15233519 | 15233519 | PRJNA760976_P_NODE_20392_length_346_cov_4.413919_g20071_i0 | PRJNA760976 | 20392 | 346 | 4.413919 | 15.27215974 | Vannellidae | 95227 | Discosea | other_Eukaryota | 569 | 7.31e-158 | NTclustered | gi|62865947|gb|AY929922.1| | 325065 | g20071 | i0 | 96.286 | 100.439306358382 | 350 | 8 | 99 | 3 | 1 | 345 | 572 | 921 | Platyamoeba sp. strain CAZ7/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 34752 | 569 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba sp. strain CAZ7/I | |||
| 16045092 | 16045092 | PRJNA760976_P_NODE_7893_length_492_cov_1.608592_g7574_i0 | PRJNA760976 | 7893 | 492 | 1.608592 | 7.91427264 | Vannella sp. strain CAZ6/I | 325077 | Discosea | other_Eukaryota | 514 | 5.09e-141 | NTclustered | gi|62865939|gb|AY929914.1| | 325077 | g7574 | i0 | 96.238 | 63.6524390243902 | 319 | 3 | 64 | 5 | 176 | 492 | 3 | 314 | Vannella sp. strain CAZ6/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 31317 | 514 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain CAZ6/I | |||
| 22419639 | 22419639 | PRJNA760976_P_NODE_22538_length_334_cov_3.030651_g22217_i0 | PRJNA760976 | 22538 | 334 | 3.030651 | 10.12237434 | Paravannella minima | 1443144 | Discosea | other_Eukaryota | 113 | 1.42e-20 | NTclustered | gi|1583105587|ref|NC_040955.1| | 1443144 | g22217 | i0 | 74.214 | 3.44610778443114 | 318 | 61 | 93 | 18 | 16 | 325 | 2782 | 3086 | Paravannella minima mitochondrion, complete genome | blastn | 1151 | 113 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Paravannella | Paravannella minima |
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);;