contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA917598" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 897282 | 897282 | PRJNA917598_P_NODE_96481_length_237_cov_3.786585_g95537_i0 | PRJNA917598 | 96481 | 237 | 3.786585 | 8.97420645 | Vannella sp. strain 4354/I | 325074 | Discosea | other_Eukaryota | 416 | 6.5499999999999985e-112 | NTclustered | gi|62865936|gb|AY929911.1| | 325074 | g95537 | i0 | 98.312 | 87.0042194092827 | 237 | 4 | 100 | 0 | 1 | 237 | 771 | 1007 | Vannella sp. strain 4354/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 20620 | 416 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain 4354/I | |||
| 7273747 | 7273747 | PRJNA917598_P_NODE_23026_length_483_cov_1.675610_g22084_i0 | PRJNA917598 | 23026 | 483 | 1.67561 | 8.0931963 | Acanthamoeba sp. | 5756 | Discosea | other_Eukaryota | 243 | 2.6e-59 | NTclustered | gi|1496296861|gb|MG924706.1| | 5756 | g22084 | i0 | 76.559 | 83.0393374741201 | 465 | 95 | 95 | 11 | 11 | 468 | 629 | 172 | Acanthamoeba sp. isolate OSU08-016 cytochrome c oxidase subunit I (COXI) gene, partial cds; mitochondrial | blastn | 40108 | 243 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba sp. | |||
| 7275146 | 7275146 | PRJNA917598_P_NODE_80286_length_251_cov_0.865169_g79342_i0 | PRJNA917598 | 80286 | 251 | 0.865169 | 2.17157419 | Acanthamoeba comandoni | 65659 | Discosea | other_Eukaryota | 113 | 1.03e-20 | NTclustered | gi|28194600|gb|AF479544.1| | 65659 | g79342 | i0 | 76.777 | 25.6334661354582 | 211 | 44 | 83 | 4 | 2 | 210 | 894 | 687 | Acanthamoeba comandoni strain ATCC 30135 16S small subunit ribosomal RNA gene, partial sequence; mitochondrial gene for mitochondrial product | blastn | 6434 | 113 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba comandoni | |||
| 11099081 | 11099081 | PRJNA917598_P_NODE_24469_length_467_cov_3.081218_g23526_i0 | PRJNA917598 | 24469 | 467 | 3.081218 | 14.38928806 | Thecamoeba sp. | 1973049 | Discosea | other_Eukaryota | 111 | 7.38e-20 | NTclustered | gi|2716342294|gb|PP647606.1| | 1973049 | g23526 | i0 | 84.034 | 0.481798715203426 | 119 | 15 | 25 | 1 | 204 | 318 | 908 | 1026 | Thecamoeba sp. isolate SK13-4H small subunit ribosomal RNA gene, partial sequence | blastn | 225 | 111 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba sp. | |||
| 11100720 | 11100720 | PRJNA917598_P_NODE_91949_length_243_cov_1.682353_g91005_i0 | PRJNA917598 | 91949 | 243 | 1.682353 | 4.08811779 | Acanthamoeba polyphaga | 5757 | Discosea | other_Eukaryota | 329 | 9.04e-86 | NTclustered | gi|932090235|gb|KP054475.2| | 5757 | g91005 | i0 | 91.701 | 6.04115226337449 | 241 | 15 | 99 | 4 | 1 | 240 | 476 | 240 | Acanthamoeba polyphaga strain Linc Ap-1 mitochondrion, complete genome | blastn | 1468 | 329 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba polyphaga | |||
| 13649571 | 13649571 | PRJNA917598_P_NODE_40311_length_361_cov_2.145833_g39367_i0 | PRJNA917598 | 40311 | 361 | 2.145833 | 7.74645713 | Thecamoeba quadrilineata | 343530 | Discosea | other_Eukaryota | 243 | 1.89e-59 | NTclustered | gi|2386968834|ref|NC_068853.1| | 343530 | g39367 | i0 | 87.264 | 51.1412742382271 | 212 | 27 | 59 | 0 | 128 | 339 | 11157 | 10946 | Thecamoeba quadrilineata mitochondrion, complete genome | blastn | 18462 | 243 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba quadrilineata | |||
| 14005808 | 14005808 | PRJNA917598_P_NODE_95591_length_241_cov_0.916667_g94647_i0 | PRJNA917598 | 95591 | 241 | 0.916667 | 2.20916747 | Paramoeba | 200890 | Discosea | other_Eukaryota | 182 | 2.65e-41 | NTclustered | gi|1079488025|ref|NC_031417.1| | 180228 | g94647 | i0 | 90.58 | 81.3236514522822 | 138 | 12 | 57 | 1 | 63 | 200 | 42184 | 42048 | Paramoeba pemaquidensis culture-collection CCAP:1560/4 mitochondrion, complete genome | blastn | 19599 | 182 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba pemaquidensis | ||
| 14923914 | 14923914 | PRJNA917598_P_NODE_4112_length_1225_cov_3.233507_g3493_i0 | PRJNA917598 | 4112 | 1225 | 3.233507 | 39.61046075 | Thecamoeba quadrilineata | 343530 | Discosea | other_Eukaryota | 804 | 0 | NTclustered | gi|2386968834|ref|NC_068853.1| | 343530 | g3493 | i0 | 80.818 | 3.71020408163265 | 1100 | 147 | 88 | 42 | 99 | 1173 | 10776 | 9716 | Thecamoeba quadrilineata mitochondrion, complete genome | blastn | 4545 | 804 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba quadrilineata | |||
| 17474121 | 17474121 | PRJNA917598_P_NODE_37814_length_373_cov_2.056667_g36870_i0 | PRJNA917598 | 37814 | 373 | 2.056667 | 7.67136791 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 595 | 1.3099999999999996e-165 | NTclustered | gi|330902858|gb|JF298255.1| | 1017091 | g36870 | i0 | 95.467 | 23.3592493297587 | 375 | 14 | 100 | 3 | 1 | 373 | 656 | 1029 | Cochliopodium larifeili clone 904 18S ribosomal RNA gene, partial sequence | blastn | 8713 | 595 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 18747975 | 18747975 | PRJNA917598_P_NODE_55515_length_305_cov_3.745690_g54571_i0 | PRJNA917598 | 55515 | 305 | 3.74569 | 11.4243545 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 501 | 2.35e-137 | NTclustered | gi|330902861|gb|JF298256.1| | 1017091 | g54571 | i0 | 96.393 | 12.6295081967213 | 305 | 9 | 99 | 2 | 2 | 305 | 345 | 42 | Cochliopodium larifeili clone 907 18S ribosomal RNA gene, partial sequence | blastn | 3852 | 501 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili |
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);;