contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJEB12296" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25500855 | 25500855 | PRJEB12296_S_NODE_8113_length_182_cov_2.102041_g8081_i0 | PRJEB12296 | 8113 | 182 | 2.102041 | 3.82571462 | Ripella sp. 8 | 1973050 | Discosea | other_Eukaryota | 235 | 1.43e-57 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g8081 | i0 | 98.496 | 57.3516483516484 | 133 | 2 | 73 | 0 | 1 | 133 | 170 | 38 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 10438 | 235 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 25606819 | 25606819 | PRJEB12296_S_NODE_1609_length_317_cov_9.170213_g1577_i0 | PRJEB12296 | 1609 | 317 | 9.170213 | 29.06957521 | Vermistella | 354201 | Discosea | other_Eukaryota | 100 | 1.05e-16 | NTclustered | gi|766943132|gb|KJ874207.1| | 1628650 | g1577 | i0 | 90.667 | 25.9116719242902 | 75 | 7 | 24 | 0 | 1 | 75 | 1596 | 1522 | Vermistella sp. TT-2015a strain SV198 clone 1 18S ribosomal RNA gene, partial sequence | blastn | 8214 | 100 | 1 | Eukaryota | Amoebozoa | Discosea | Stygamoebida | Vermistella | Vermistella arctica | ||||
| 25636587 | 25636587 | PRJEB12296_S_NODE_3834_length_233_cov_2.348485_g3802_i0 | PRJEB12296 | 3834 | 233 | 2.348485 | 5.47197005 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 383 | 6.51e-102 | NTclustered | gi|330902855|gb|JF298253.1| | 1017091 | g3802 | i0 | 99.524 | 60.725321888412 | 210 | 1 | 90 | 0 | 1 | 210 | 643 | 434 | Cochliopodium larifeili clone 901 18S ribosomal RNA gene, partial sequence | blastn | 14149 | 383 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 25772744 | 25772744 | PRJEB12296_S_NODE_2763_length_264_cov_278.336245_g2731_i0 | PRJEB12296 | 2763 | 264 | 278.336245 | 734.8076868 | Thecamoeba similis | 242545 | Discosea | other_Eukaryota | 243 | 1.33e-59 | NTclustered | gi|33946350|gb|AY294154.1| | 242545 | g2731 | i0 | 89.286 | 72.5909090909091 | 196 | 18 | 73 | 3 | 40 | 233 | 972 | 1166 | Thecamoeba similis actin mRNA, complete cds | blastn | 19164 | 243 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba similis | |||
| 25908905 | 25908905 | PRJEB12296_S_NODE_2500_length_274_cov_1.820084_g2468_i0 | PRJEB12296 | 2500 | 274 | 1.820084 | 4.98703016 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 466 | 7.58e-127 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g2468 | i0 | 98.485 | 35.985401459854 | 264 | 4 | 96 | 0 | 1 | 264 | 871 | 1134 | 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 | 9860 | 466 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 26181257 | 26181257 | PRJEB12296_S_NODE_5582_length_204_cov_1.360947_g5550_i0 | PRJEB12296 | 5582 | 204 | 1.360947 | 2.77633188 | Cochliopodium larifeili | 1017091 | Discosea | other_Eukaryota | 294 | 2.68e-75 | NTclustered | gi|330902855|gb|JF298253.1| | 1017091 | g5550 | i0 | 92.683 | 12.6617647058824 | 205 | 14 | 100 | 1 | 1 | 204 | 654 | 858 | Cochliopodium larifeili clone 901 18S ribosomal RNA gene, partial sequence | blastn | 2583 | 294 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium larifeili | |||
| 26317022 | 26317022 | PRJEB12296_S_NODE_7231_length_188_cov_4.522876_g7199_i0 | PRJEB12296 | 7231 | 188 | 4.522876 | 8.50300688 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 99 | 2.04e-16 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g7199 | i0 | 87.356 | 1.61702127659574 | 87 | 10 | 46 | 1 | 103 | 188 | 6888 | 6802 | 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 | 304 | 99 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 26453071 | 26453071 | PRJEB12296_S_NODE_11208_length_168_cov_5.736842_g11176_i0 | PRJEB12296 | 11208 | 168 | 5.736842 | 9.63789456 | Protacanthamoeba bohemica | 325062 | Discosea | other_Eukaryota | 198 | 1.7099999999999997e-46 | NTclustered | gi|2806326584|gb|PQ345834.1| | 325062 | g11176 | i0 | 90.604 | 36.1488095238095 | 149 | 14 | 89 | 0 | 3 | 151 | 143 | 291 | Protacanthamoeba bohemica isolate 6FSb1 small subunit ribosomal RNA gene, partial sequence | blastn | 6073 | 198 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Protacanthamoeba | Protacanthamoeba bohemica | |||
| 26453106 | 26453106 | PRJEB12296_S_NODE_1440_length_328_cov_8.696246_g1408_i0 | PRJEB12296 | 1440 | 328 | 8.696246 | 28.52368688 | Protacanthamoeba bohemica | 325062 | Discosea | other_Eukaryota | 446 | 1.21e-120 | NTclustered | gi|62825358|gb|AY960120.1| | 325062 | g1408 | i0 | 91.541 | 79.015243902439 | 331 | 16 | 100 | 7 | 1 | 328 | 1118 | 797 | Protacanthamoeba bohemica small subunit ribosomal RNA gene, complete sequence | blastn | 25917 | 446 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Protacanthamoeba | Protacanthamoeba bohemica | |||
| 26453233 | 26453233 | PRJEB12296_S_NODE_4136_length_226_cov_3.722513_g4104_i0 | PRJEB12296 | 4136 | 226 | 3.722513 | 8.41287938 | Protacanthamoeba bohemica | 325062 | Discosea | other_Eukaryota | 272 | 1.42e-68 | NTclustered | gi|2806326584|gb|PQ345834.1| | 325062 | g4104 | i0 | 91.584 | 65.8230088495575 | 202 | 10 | 88 | 6 | 13 | 211 | 276 | 473 | Protacanthamoeba bohemica isolate 6FSb1 small subunit ribosomal RNA gene, partial sequence | blastn | 14876 | 272 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Protacanthamoeba | Protacanthamoeba bohemica |
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);;