contig_metadata
11 rows where bioproject = "PRJNA983848", tax_clade = "Sar" and tax_phylum = "Perkinsozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 969679 | 969679 | PRJNA983848_P_NODE_51801_length_475_cov_7.106965_g45924_i0 | PRJNA983848 | 51801 | 475 | 7.106965 | 33.75808375 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 1.6499999999999998e-42 | NR | KAF4718031.1 | 32597 | g45924 | i0 | 80.2 | 12.4421052631579 | 91 | 18 | 57.5 | 0 | 6 | 278 | 84 | 174 | KAF4718031.1 40S ribosomal protein S9 [Perkinsus olseni] | diamond | 5910 | 150 | 0.993333333333333 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 23921050 | 23921050 | PRJNA983848_P_NODE_167579_length_201_cov_15.171875_g161696_i0 | PRJNA983848 | 167579 | 201 | 15.171875 | 30.49546875 | Gadixcellia gadi | 2759754 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 4.7199999999999996e-23 | NTclustered | gi|1148361587|gb|KY628819.1| | 2759754 | g161696 | i0 | 84.874 | 1.23383084577114 | 119 | 18 | 59 | 0 | 70 | 188 | 5230 | 5112 | Gadixcellia gadi small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 248 | 121 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Xcellidae | Gadixcellia | Gadixcellia gadi | |||
| 25197442 | 25197442 | PRJNA983848_P_NODE_94060_length_314_cov_1.294606_g88177_i0 | PRJNA983848 | 94060 | 314 | 1.294606 | 4.06506284 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 57.4 | 5.58e-7 | NR | KAF4653926.1 | 330153 | g88177 | i0 | 60.9 | 0.439490445859873 | 46 | 13 | 39.2 | 1 | 313 | 191 | 46 | 91 | KAF4653926.1 hypothetical protein FOL47_010228 [Perkinsus chesapeaki] | diamond | 138 | 57.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 27468887 | 27468887 | PRJNA983848_P_NODE_155343_length_244_cov_1.350877_g149460_i0 | PRJNA983848 | 155343 | 244 | 1.350877 | 3.29613988 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 64.3 | 4.45e-10 | NR | XP_002786483.1 | 423536 | g149460 | i0 | 40 | 1.89344262295082 | 80 | 46 | 98.4 | 1 | 242 | 3 | 51 | 128 | XP_002786483.1 nucleotidyltransferase, putative [Perkinsus marinus ATCC 50983] | diamond | 462 | 64.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27847525 | 27847525 | PRJNA983848_P_NODE_48224_length_507_cov_1.377880_g42351_i0 | PRJNA983848 | 48224 | 507 | 1.37788 | 6.9858516 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 1.22e-8 | NR | XP_002786644.1 | 423536 | g42351 | i0 | 56 | 1.82248520710059 | 50 | 22 | 29.6 | 0 | 260 | 111 | 1 | 50 | XP_002786644.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 924 | 63.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 30032451 | 30032451 | PRJNA983848_P_NODE_68991_length_382_cov_1.009709_g63108_i0 | PRJNA983848 | 68991 | 382 | 1.009709 | 3.85708838 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 8.44e-45 | NR | KAF4744982.1 | 32597 | g63108 | i0 | 63.2 | 8.64659685863874 | 125 | 46 | 98.2 | 0 | 1 | 375 | 112 | 236 | KAF4744982.1 3-ketoacyl-CoA thiolase, peroxisomal, partial [Perkinsus olseni] | diamond | 3303 | 157 | 0.993630573248408 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30317211 | 30317211 | PRJNA983848_P_NODE_142332_length_251_cov_0.876404_g136449_i0 | PRJNA983848 | 142332 | 251 | 0.876404 | 2.19977404 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0473 | NR | KAF4709579.1 | 32597 | g136449 | i0 | 45 | 1.51792828685259 | 40 | 22 | 47.8 | 0 | 122 | 3 | 115 | 154 | KAF4709579.1 hypothetical protein FOZ63_033961, partial [Perkinsus olseni] | diamond | 381 | 42.7 | 0.992974238875878 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30405928 | 30405928 | PRJNA983848_P_NODE_158733_length_242_cov_3.159763_g152850_i0 | PRJNA983848 | 158733 | 242 | 3.159763 | 7.64662646 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 1.37e-25 | NR | XP_002783520.1 | 423536 | g152850 | i0 | 71.3 | 1.98347107438017 | 80 | 23 | 99.2 | 0 | 242 | 3 | 40 | 119 | XP_002783520.1 T-complex protein 1 subunit theta, putative [Perkinsus marinus ATCC 50983] | diamond | 480 | 108 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 31960476 | 31960476 | PRJNA983848_P_NODE_49697_length_493_cov_3.214286_g43821_i0 | PRJNA983848 | 49697 | 493 | 3.214286 | 15.84642998 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 223 | 2.85e-70 | NR | KAF4689453.1 | 32597 | g43821 | i0 | 75.2 | 2.59229208924949 | 141 | 35 | 85.8 | 0 | 424 | 2 | 1 | 141 | KAF4689453.1 40S ribosomal protein S4, X isoform [Perkinsus olseni] | diamond | 1278 | 223 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32302888 | 32302888 | PRJNA983848_P_NODE_134479_length_256_cov_1.704918_g128596_i0 | PRJNA983848 | 134479 | 256 | 1.704918 | 4.36459008 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 55.8 | 3.13e-7 | NR | XP_002765022.1 | 423536 | g128596 | i0 | 39.4 | 1.546875 | 66 | 40 | 77.3 | 0 | 5 | 202 | 88 | 153 | XP_002765022.1 hypothetical protein Pmar_PMAR004478, partial [Perkinsus marinus ATCC 50983] | diamond | 396 | 55.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 32845083 | 32845083 | PRJNA983848_P_NODE_51880_length_475_cov_2.089552_g46003_i0 | PRJNA983848 | 51880 | 475 | 2.089552 | 9.925372 | Perkinsida | 27998 | SAR_Eukaryotes | SAR_Eukaryotes | 88.6 | 4.53e-17 | NR | KAF4653858.1 | 330153 | g46003 | i0 | 57.4 | 0.852631578947368 | 68 | 29 | 42.9 | 0 | 475 | 272 | 543 | 610 | KAF4653858.1 hypothetical protein FOL47_010271 [Perkinsus chesapeaki] | diamond | 405 | 88.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki |
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);;