contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJEB14175" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25510037 | 25510037 | PRJEB14175_P_NODE_51137_length_521_cov_8.626087_g48896_i0 | PRJEB14175 | 51137 | 521 | 8.626087 | 44.94191327 | Thecamoeba foliovenanda | 2653195 | Discosea | other_Eukaryota | 848 | 0 | NTclustered | gi|1758284524|gb|MN544291.1| | 2653195 | g48896 | i0 | 97.047 | 40.5278310940499 | 508 | 8 | 98 | 5 | 12 | 519 | 862 | 1362 | Thecamoeba foliovenanda strain Ta68 small subunit ribosomal RNA gene, partial sequence | blastn | 21115 | 848 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba foliovenanda | |||
| 25637500 | 25637500 | PRJEB14175_P_NODE_115010_length_328_cov_5.142322_g112744_i0 | PRJEB14175 | 115010 | 328 | 5.142322 | 16.86681616 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 442 | 1.5699999999999994e-119 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g112744 | i0 | 90.991 | 34.0762195121951 | 333 | 23 | 100 | 6 | 1 | 328 | 1167 | 837 | 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 | 11177 | 442 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 25641482 | 25641482 | PRJEB14175_P_NODE_200034_length_228_cov_2.209581_g197767_i0 | PRJEB14175 | 200034 | 228 | 2.209581 | 5.03784468 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 211 | 3.17e-50 | NTclustered | gi|470506207|ref|XM_004348670.1| | 1257118 | g197767 | i0 | 92.517 | 0.644736842105263 | 147 | 11 | 64 | 0 | 74 | 220 | 396 | 250 | Acanthamoeba castellanii str. Neff actin binding protein (ACA1_035360), partial mRNA | blastn | 147 | 211 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 25642551 | 25642551 | PRJEB14175_P_NODE_22538_length_774_cov_13.193548_g20625_i0 | PRJEB14175 | 22538 | 774 | 13.193548 | 102.11806152 | Thecamoeba similis | 242545 | Discosea | other_Eukaryota | 987 | 0 | NTclustered | gi|33946350|gb|AY294154.1| | 242545 | g20625 | i0 | 90.996 | 93.2906976744186 | 733 | 65 | 95 | 1 | 43 | 774 | 1160 | 428 | Thecamoeba similis actin mRNA, complete cds | blastn | 72207 | 987 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba similis | |||
| 25744635 | 25744635 | PRJEB14175_P_NODE_173506_length_251_cov_1.589474_g171239_i0 | PRJEB14175 | 173506 | 251 | 1.589474 | 3.98957974 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 425 | 1.16e-114 | NTclustered | gi|2979652|gb|AF019052.1|AF019052 | 5757 | g171239 | i0 | 100 | 92.7011952191235 | 230 | 0 | 92 | 0 | 1 | 230 | 914 | 685 | Acanthamoeba polyphaga Panola Mountain 18S ribosomal RNA gene, partial sequence | blastn | 23268 | 425 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba polyphaga | |||
| 25773893 | 25773893 | PRJEB14175_P_NODE_119139_length_321_cov_3.200000_g116873_i0 | PRJEB14175 | 119139 | 321 | 3.2 | 10.272 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 111 | 4.9e-20 | NTclustered | gi|470515612|ref|XM_004352895.1| | 1257118 | g116873 | i0 | 91.358 | 3.20560747663551 | 81 | 7 | 25 | 0 | 220 | 300 | 389 | 309 | Acanthamoeba castellanii str. Neff ras-related C3 botulinum toxin substrate 3 (rho family, small GTP binding protein Rac3), putative (ACA1_070050), partial mRNA | blastn | 1029 | 111 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 25780415 | 25780415 | PRJEB14175_P_NODE_267971_length_192_cov_4.259542_g265703_i0 | PRJEB14175 | 267971 | 192 | 4.259542 | 8.17832064 | Platyamoeba sp. strain CAZ7/I | 325065 | Discosea | other_Eukaryota | 316 | 5.31e-82 | NTclustered | gi|62865947|gb|AY929922.1| | 325065 | g265703 | i0 | 97.826 | 96.1875 | 184 | 3 | 96 | 1 | 1 | 184 | 554 | 372 | Platyamoeba sp. strain CAZ7/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 18468 | 316 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba sp. strain CAZ7/I | |||
| 25920306 | 25920306 | PRJEB14175_P_NODE_87852_length_386_cov_25.932308_g85587_i0 | PRJEB14175 | 87852 | 386 | 25.932308 | 100.09870888 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 233 | 1.2299999999999998e-56 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g85587 | i0 | 95.862 | 32.9507772020725 | 145 | 4 | 70 | 2 | 24 | 166 | 6181 | 6325 | 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 | 12719 | 233 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 26015395 | 26015395 | PRJEB14175_P_NODE_106820_length_343_cov_22.609929_g104554_i0 | PRJEB14175 | 106820 | 343 | 22.609929 | 77.55205647 | Viridiplantae | 33090 | Discosea | other_Eukaryota | 178 | 5.13e-40 | NTclustered | gi|470510787|ref|XM_004351525.1| | 1257118 | g104554 | i0 | 92.063 | 37.4169096209913 | 126 | 10 | 37 | 0 | 195 | 320 | 591 | 466 | Acanthamoeba castellanii str. Neff ribosomal protein S7p/S5e, putative (ACA1_149890), partial mRNA | blastn | 12834 | 178 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 26051265 | 26051265 | PRJEB14175_P_NODE_234021_length_207_cov_2.191781_g231753_i0 | PRJEB14175 | 234021 | 207 | 2.191781 | 4.53698667 | Paramoeba pemaquidensis | 180228 | Discosea | other_Eukaryota | 106 | 1.37e-18 | NTclustered | gi|145386788|gb|EF216913.1| | 180228 | g231753 | i0 | 79.167 | 25.0966183574879 | 168 | 23 | 79 | 9 | 35 | 198 | 1644 | 1485 | Paramoeba pemaquidensis strain NP251002 28S large subunit ribosomal RNA gene, partial sequence | blastn | 5195 | 106 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba pemaquidensis | ||
| 26317612 | 26317612 | PRJEB14175_P_NODE_110607_length_336_cov_7.407273_g108341_i0 | PRJEB14175 | 110607 | 336 | 7.407273 | 24.88843728 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 553 | 7.13e-153 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g108341 | i0 | 97.819 | 37.6875 | 321 | 6 | 95 | 1 | 1 | 320 | 1167 | 847 | 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 | 12663 | 553 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 26325588 | 26325588 | PRJEB14175_P_NODE_39023_length_597_cov_11.548507_g36839_i0 | PRJEB14175 | 39023 | 597 | 11.548507 | 68.94458679 | Acanthamoeba polyphaga | 5757 | Discosea | other_Eukaryota | 243 | 3.2700000000000002e-59 | NTclustered | gi|932090235|gb|KP054475.2| | 5757 | g36839 | i0 | 78.919 | 56.606365159129 | 370 | 68 | 61 | 10 | 124 | 488 | 2185 | 2549 | Acanthamoeba polyphaga strain Linc Ap-1 mitochondrion, complete genome | blastn | 33794 | 243 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba polyphaga | |||
| 26326790 | 26326790 | PRJEB14175_P_NODE_5895_length_1418_cov_30.511422_g4866_i0 | PRJEB14175 | 5895 | 1418 | 30.511422 | 432.65196396 | Thecamoeba quadrilineata | 343530 | Discosea | other_Eukaryota | 654 | 0 | NTclustered | gi|2386968834|ref|NC_068853.1| | 343530 | g4866 | i0 | 81.193 | 7.43229901269394 | 872 | 113 | 60 | 33 | 104 | 953 | 10558 | 9716 | Thecamoeba quadrilineata mitochondrion, complete genome | blastn | 10539 | 654 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba quadrilineata | |||
| 26457012 | 26457012 | PRJEB14175_P_NODE_174264_length_250_cov_3.158730_g171997_i0 | PRJEB14175 | 174264 | 250 | 3.15873 | 7.896825 | Thecamoeba similis | 242545 | Discosea | other_Eukaryota | 363 | 9.209999999999997e-96 | NTclustered | gi|33946350|gb|AY294154.1| | 242545 | g171997 | i0 | 93.443 | 96.656 | 244 | 16 | 98 | 0 | 7 | 250 | 994 | 751 | Thecamoeba similis actin mRNA, complete cds | blastn | 24164 | 363 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba similis | |||
| 26563485 | 26563485 | PRJEB14175_P_NODE_69192_length_443_cov_13.128272_g66934_i0 | PRJEB14175 | 69192 | 443 | 13.128272 | 58.15824496 | Vannella | 95228 | Discosea | other_Eukaryota | 791 | 0 | NTclustered | gi|319659363|gb|GU320600.1| | 943213 | g66934 | i0 | 98.871 | 99.647855530474 | 443 | 5 | 100 | 0 | 1 | 443 | 42 | 484 | Vannella sp. COHH 72 18S ribosomal RNA gene, partial sequence | blastn | 44144 | 797 | 0.992471769134254 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. COHH 72 |
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);;