contig_metadata
10 rows where bioproject = "PRJNA597223", tax_clade = "Amoebozoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1844591 | 1844591 | PRJNA597223_P_NODE_27902_length_290_cov_1.792157_g26056_i0 | PRJNA597223 | 27902 | 290 | 1.792157 | 5.1972553 | Thecamoeba quadrilineata | 343530 | Discosea | other_Eukaryota | 71.3 | 7.41e-8 | NTclustered | gi|2386968834|ref|NC_068853.1| | 343530 | g26056 | i0 | 89.474 | 0.196551724137931 | 57 | 4 | 20 | 2 | 74 | 130 | 9326 | 9380 | Thecamoeba quadrilineata mitochondrion, complete genome | blastn | 57 | 71.3 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba quadrilineata | |||
| 5673091 | 5673091 | PRJNA597223_P_NODE_62745_length_183_cov_2.331081_g60899_i0 | PRJNA597223 | 62745 | 183 | 2.331081 | 4.26587823 | Sappinia pedata | 472956 | Discosea | other_Eukaryota | 333 | 4.97e-87 | NTclustered | gi|157673611|gb|EU004599.1| | 472956 | g60899 | i0 | 99.454 | 61.2896174863388 | 183 | 1 | 100 | 0 | 1 | 183 | 237 | 419 | Sappinia pedata strain UK05-34-3a-M internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 11216 | 333 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Sappinia | Sappinia pedata | |||
| 5673200 | 5673200 | PRJNA597223_P_NODE_7065_length_655_cov_4.864516_g5623_i0 | PRJNA597223 | 7065 | 655 | 4.864516 | 31.8625798 | Korotnevella jeppesenii | 1678066 | Discosea | other_Eukaryota | 523 | 1.1499999999999996e-143 | NTclustered | gi|861553759|gb|KP719186.1| | 1678066 | g5623 | i0 | 97.705 | 48.4167938931298 | 305 | 5 | 46 | 2 | 1 | 304 | 452 | 149 | Korotnevella jeppesenii strain A4DVDPB clone 4 small subunit ribosomal RNA gene, partial sequence | blastn | 31713 | 523 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Korotnevella | Korotnevella jeppesenii | ||
| 5673377 | 5673377 | PRJNA597223_P_NODE_85465_length_152_cov_1.846154_g83619_i0 | PRJNA597223 | 85465 | 152 | 1.846154 | 2.80615408 | Thecamoeba foliovenanda | 2653195 | Discosea | other_Eukaryota | 272 | 8.76e-69 | NTclustered | gi|2027879228|gb|MW970089.1| | 2653195 | g83619 | i0 | 100 | 3.59868421052632 | 147 | 0 | 97 | 0 | 6 | 152 | 1009 | 1155 | Thecamoeba foliovenanda strain Tfol_RM small subunit ribosomal RNA gene, partial sequence | blastn | 547 | 272 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba foliovenanda | |||
| 12619854 | 12619854 | PRJNA597223_P_NODE_71430_length_168_cov_3.135338_g69584_i0 | PRJNA597223 | 71430 | 168 | 3.135338 | 5.26736784 | Ripella | 1217112 | Discosea | other_Eukaryota | 272 | 9.95e-69 | NTclustered | gi|1269228373|gb|MF683498.1| | 2047821 | g69584 | i0 | 95.858 | 100.910714285714 | 169 | 6 | 100 | 1 | 1 | 168 | 517 | 349 | Ripella platypodia clone 26.9.30 18S ribosomal RNA gene, partial sequence | blastn | 16953 | 274 | 0.992700729927007 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella platypodia | |||
| 15169001 | 15169001 | PRJNA597223_P_NODE_83012_length_154_cov_2.806723_g81166_i0 | PRJNA597223 | 83012 | 154 | 2.806723 | 4.32235342 | Vannella | 95228 | Discosea | other_Eukaryota | 278 | 1.92e-70 | NTclustered | gi|399764233|gb|JQ271744.1| | 1215648 | g81166 | i0 | 99.346 | 98.4415584415584 | 153 | 1 | 99 | 0 | 1 | 153 | 1789 | 1637 | Vannella sp. JRF2 18S ribosomal RNA gene, partial sequence | blastn | 15160 | 278 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. JRF2 | |||
| 15871915 | 15871915 | PRJNA597223_P_NODE_52013_length_193_cov_2.031646_g50167_i0 | PRJNA597223 | 52013 | 193 | 2.031646 | 3.92107678 | Ripella sp. PS2 | 1217116 | Discosea | other_Eukaryota | 185 | 1.57e-42 | NTclustered | gi|399764205|gb|JQ271716.1| | 1217116 | g50167 | i0 | 84.264 | 102.60103626943 | 197 | 24 | 100 | 7 | 1 | 193 | 1176 | 1369 | Ripella sp. PS2 18S ribosomal RNA gene, partial sequence | blastn | 19802 | 185 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. PS2 | |||
| 15872319 | 15872319 | PRJNA597223_P_NODE_913_length_1677_cov_355.496955_g557_i0 | PRJNA597223 | 913 | 1677 | 355.496955 | 5961.68393535 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 261 | 2.64e-64 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g557 | i0 | 76.493 | 18.2671437090042 | 536 | 92 | 31 | 27 | 161 | 687 | 1785 | 2295 | 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 | 30634 | 261 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 24794878 | 24794878 | PRJNA597223_P_NODE_12120_length_491_cov_2.537281_g10387_i0 | PRJNA597223 | 12120 | 491 | 2.537281 | 12.45804971 | Korotnevella jeppesenii | 1678066 | Discosea | other_Eukaryota | 804 | 0 | NTclustered | gi|861553739|gb|KP719185.1| | 1678066 | g10387 | i0 | 96.327 | 62.5356415478615 | 490 | 17 | 99 | 1 | 1 | 490 | 1079 | 591 | Korotnevella jeppesenii strain A1JEPDK small subunit ribosomal RNA gene, partial sequence | blastn | 30705 | 804 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Korotnevella | Korotnevella jeppesenii | ||
| 30205951 | 30205951 | PRJNA597223_P_NODE_32392_length_261_cov_1.181416_g30546_i0 | PRJNA597223 | 32392 | 261 | 1.181416 | 3.08349576 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 75.1 | 9.56e-14 | NR | XP_004339668.1 | 1257118 | g30546 | i0 | 43.9 | 0.942528735632184 | 82 | 46 | 94.3 | 0 | 252 | 7 | 182 | 263 | XP_004339668.1 Ras subfamily protein, putative [Acanthamoeba castellanii str. Neff] | diamond | 246 | 75.1 | 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);;