contig_metadata
20 rows where bioproject = "PRJNA1120060" and tax_phylum = "Fornicata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16846703 | 16846703 | PRJNA1120060_P_NODE_662814_length_339_cov_1.030075_g645030_i0 | PRJNA1120060 | 662814 | 339 | 1.030075 | 3.49195425 | Spironucleus vortens | 58336 | Fornicata | other_Eukaryota | 52.8 | 0.032 | NTclustered | gi|74474989|gb|AC166554.2| | 58336 | g645030 | i0 | 100 | 0.0825958702064897 | 28 | 0 | 8 | 0 | 54 | 81 | 18957 | 18930 | Spironucleus vortens clone JGIBAWF-5A16, complete sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus vortens | |||
| 26626036 | 26626036 | PRJNA1120060_P_NODE_2798961_length_246_cov_1.421965_g2780875_i0 | PRJNA1120060 | 2798961 | 246 | 1.421965 | 3.4980339 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 47.8 | 2.75e-4 | NR | GKT29437.1 | 2918883 | g2780875 | i0 | 69.2 | 0.317073170731707 | 26 | 8 | 31.7 | 0 | 167 | 244 | 101 | 126 | GKT29437.1 hypothetical protein ADUPG1_005257, partial [Aduncisulcus paluster] | diamond | 78 | 47.8 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 27100054 | 27100054 | PRJNA1120060_P_NODE_1677022_length_286_cov_1.427230_g1659021_i0 | PRJNA1120060 | 1677022 | 286 | 1.42723 | 4.0818778 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 45.8 | 0.00459 | NR | GKT30465.1 | 2918883 | g1659021 | i0 | 72.7 | 1.3951048951049 | 22 | 6 | 23.1 | 0 | 85 | 150 | 252 | 273 | GKT30465.1 hypothetical protein ADUPG1_001518, partial [Aduncisulcus paluster] | diamond | 399 | 45.8 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 27131269 | 27131269 | PRJNA1120060_P_NODE_1594142_length_289_cov_2.712963_g1576149_i0 | PRJNA1120060 | 1594142 | 289 | 2.712963 | 7.84046307 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 45.4 | 0.00628 | NR | GKT30465.1 | 2918883 | g1576149 | i0 | 72.7 | 1.37024221453287 | 22 | 6 | 22.8 | 0 | 150 | 215 | 251 | 272 | GKT30465.1 hypothetical protein ADUPG1_001518, partial [Aduncisulcus paluster] | diamond | 396 | 45.4 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 27606225 | 27606225 | PRJNA1120060_P_NODE_2342424_length_259_cov_4.026882_g2324363_i0 | PRJNA1120060 | 2342424 | 259 | 4.026882 | 10.42962438 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 54.3 | 1.57e-6 | NR | GKT32194.1 | 2918883 | g2324363 | i0 | 60.6 | 0.776061776061776 | 33 | 13 | 38.2 | 0 | 103 | 5 | 84 | 116 | GKT32194.1 hypothetical protein ADUPG1_002242, partial [Aduncisulcus paluster] | diamond | 201 | 54.3 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 27701795 | 27701795 | PRJNA1120060_P_NODE_3442184_length_212_cov_4.690647_g3424059_i0 | PRJNA1120060 | 3442184 | 212 | 4.690647 | 9.94417164 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 47 | 4.87e-4 | NR | GKT25352.1 | 2918883 | g3424059 | i0 | 34.3 | 0.990566037735849 | 70 | 44 | 96.2 | 1 | 3 | 206 | 58 | 127 | GKT25352.1 hypothetical protein ADUPG1_004639, partial [Aduncisulcus paluster] | diamond | 210 | 47 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 27857966 | 27857966 | PRJNA1120060_P_NODE_1498685_length_293_cov_3.431818_g1480697_i0 | PRJNA1120060 | 1498685 | 293 | 3.431818 | 10.05522674 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 50.4 | 6.35e-5 | NR | GKT32194.1 | 2918883 | g1480697 | i0 | 54.3 | 3.61433447098976 | 35 | 16 | 35.8 | 0 | 269 | 165 | 86 | 120 | GKT32194.1 hypothetical protein ADUPG1_002242, partial [Aduncisulcus paluster] | diamond | 1059 | 50.4 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 28301274 | 28301274 | PRJNA1120060_P_NODE_3298766_length_227_cov_2.623377_g3280658_i0 | PRJNA1120060 | 3298766 | 227 | 2.623377 | 5.95506579 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 44.3 | 0.00869 | NR | GKT35807.1 | 2918883 | g3280658 | i0 | 42.2 | 1.18942731277533 | 45 | 26 | 59.5 | 0 | 153 | 19 | 341 | 385 | GKT35807.1 hypothetical protein ADUPG1_008890 [Aduncisulcus paluster] | diamond | 270 | 44.3 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 29437068 | 29437068 | PRJNA1120060_P_NODE_2440650_length_256_cov_1.584699_g2422581_i0 | PRJNA1120060 | 2440650 | 256 | 1.584699 | 4.05682944 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 43.9 | 0.00889 | NR | GKT29437.1 | 2918883 | g2422581 | i0 | 60 | 1.16015625 | 30 | 12 | 35.2 | 0 | 127 | 216 | 101 | 130 | GKT29437.1 hypothetical protein ADUPG1_005257, partial [Aduncisulcus paluster] | diamond | 297 | 43.9 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 29563986 | 29563986 | PRJNA1120060_P_NODE_2971510_length_242_cov_0.923077_g2953416_i0 | PRJNA1120060 | 2971510 | 242 | 0.923077 | 2.23384634 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 47.8 | 3.62e-4 | NR | GKT32194.1 | 2918883 | g2953416 | i0 | 50 | 0.495867768595041 | 40 | 19 | 48.3 | 1 | 13 | 129 | 79 | 118 | GKT32194.1 hypothetical protein ADUPG1_002242, partial [Aduncisulcus paluster] | diamond | 120 | 47.8 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 30069143 | 30069143 | PRJNA1120060_P_NODE_2767292_length_247_cov_0.890805_g2749208_i0 | PRJNA1120060 | 2767292 | 247 | 0.890805 | 2.20028835 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 50.1 | 7.75e-6 | NR | GKT25557.1 | 2918883 | g2749208 | i0 | 50 | 0.607287449392713 | 50 | 25 | 60.7 | 0 | 202 | 53 | 25 | 74 | GKT25557.1 polyubiquitin, putative [Aduncisulcus paluster] | diamond | 150 | 50.1 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 30132670 | 30132670 | PRJNA1120060_P_NODE_538152_length_359_cov_3.101399_g520494_i0 | PRJNA1120060 | 538152 | 359 | 3.101399 | 11.13402241 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 45.4 | 0.0159 | NR | GKT19254.1 | 2918883 | g520494 | i0 | 41.3 | 0.768802228412256 | 46 | 27 | 38.4 | 0 | 198 | 61 | 254 | 299 | GKT19254.1 Transposon Tf2-6 polyprotein, partial [Aduncisulcus paluster] | diamond | 276 | 45.4 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 30354783 | 30354783 | PRJNA1120060_P_NODE_780812_length_323_cov_0.924000_g762943_i0 | PRJNA1120060 | 780812 | 323 | 0.924 | 2.98452 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 47.4 | 0.00225 | NR | GKT16077.1 | 2918883 | g762943 | i0 | 46.8 | 1.53250773993808 | 47 | 20 | 43.7 | 1 | 2 | 142 | 217 | 258 | GKT16077.1 retrovirus-like pol polyprotein, partial [Aduncisulcus paluster] | diamond | 495 | 47.4 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 30605240 | 30605240 | PRJNA1120060_P_NODE_1225293_length_310_cov_2.350211_g1207353_i0 | PRJNA1120060 | 1225293 | 310 | 2.350211 | 7.2856541 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 42.7 | 0.0406 | NR | GKT29437.1 | 2918883 | g1207353 | i0 | 59.3 | 0.261290322580645 | 27 | 11 | 26.1 | 0 | 134 | 54 | 97 | 123 | GKT29437.1 hypothetical protein ADUPG1_005257, partial [Aduncisulcus paluster] | diamond | 81 | 42.7 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 30954501 | 30954501 | PRJNA1120060_P_NODE_3414134_length_215_cov_4.021127_g3396014_i0 | PRJNA1120060 | 3414134 | 215 | 4.021127 | 8.64542305 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 45.1 | 0.00201 | NR | GKT29437.1 | 2918883 | g3396014 | i0 | 76.2 | 0.962790697674419 | 21 | 5 | 29.3 | 0 | 63 | 1 | 104 | 124 | GKT29437.1 hypothetical protein ADUPG1_005257, partial [Aduncisulcus paluster] | diamond | 207 | 45.1 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 32345507 | 32345507 | PRJNA1120060_P_NODE_2305399_length_261_cov_1.462766_g2287340_i0 | PRJNA1120060 | 2305399 | 261 | 1.462766 | 3.81781926 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 48.9 | 1.65e-4 | NR | GKT32194.1 | 2918883 | g2287340 | i0 | 51.5 | 1.09195402298851 | 33 | 16 | 37.9 | 0 | 60 | 158 | 86 | 118 | GKT32194.1 hypothetical protein ADUPG1_002242, partial [Aduncisulcus paluster] | diamond | 285 | 48.9 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 32504634 | 32504634 | PRJNA1120060_P_NODE_818519_length_318_cov_2.412245_g800615_i0 | PRJNA1120060 | 818519 | 318 | 2.412245 | 7.6709391 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 44.3 | 0.025 | NR | GIQ86013.1 | 797122 | g800615 | i0 | 37.5 | 0.528301886792453 | 56 | 32 | 50 | 1 | 71 | 229 | 339 | 394 | GIQ86013.1 hypothetical protein KIPB_007783 [Kipferlia bialata] | diamond | 168 | 44.3 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 32535069 | 32535069 | PRJNA1120060_P_NODE_2049559_length_271_cov_0.979798_g2031522_i0 | PRJNA1120060 | 2049559 | 271 | 0.979798 | 2.65525258 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 43.9 | 0.0201 | NR | GKT16077.1 | 2918883 | g2031522 | i0 | 48.8 | 0.907749077490775 | 41 | 20 | 45.4 | 1 | 6 | 128 | 220 | 259 | GKT16077.1 retrovirus-like pol polyprotein, partial [Aduncisulcus paluster] | diamond | 246 | 43.9 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 32755337 | 32755337 | PRJNA1120060_P_NODE_1875320_length_278_cov_1.063415_g1857304_i0 | PRJNA1120060 | 1875320 | 278 | 1.063415 | 2.9562937 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 49.7 | 2.01e-4 | NR | GKT31807.1 | 2918883 | g1857304 | i0 | 45.5 | 1.52158273381295 | 44 | 24 | 47.5 | 0 | 114 | 245 | 209 | 252 | GKT31807.1 LDOC1-related like protein, partial [Aduncisulcus paluster] | diamond | 423 | 49.7 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 32850945 | 32850945 | PRJNA1120060_P_NODE_638980_length_342_cov_3.349442_g621215_i0 | PRJNA1120060 | 638980 | 342 | 3.349442 | 11.45509164 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 50.4 | 1.04e-4 | NR | GKT32194.1 | 2918883 | g621215 | i0 | 65.5 | 0.254385964912281 | 29 | 10 | 25.4 | 0 | 338 | 252 | 90 | 118 | GKT32194.1 hypothetical protein ADUPG1_002242, partial [Aduncisulcus paluster] | diamond | 87 | 50.4 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster |
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);;