contig_metadata
9 rows where bioproject = "PRJNA222400" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1056573 | 1056573 | PRJNA222400_P_NODE_1621_length_401_cov_1.085227_g1588_i0 | PRJNA222400 | 1621 | 401 | 1.085227 | 4.35176027 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 131 | 1.4399999999999999e-34 | NR | KAF4650205.1 | 330153 | g1588 | i0 | 51.6 | 1.83291770573566 | 124 | 56 | 92.8 | 1 | 2 | 373 | 59 | 178 | KAF4650205.1 hypothetical protein FOL47_001370 [Perkinsus chesapeaki] | diamond | 735 | 131 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 14396242 | 14396242 | PRJNA222400_P_NODE_2852_length_281_cov_1.392241_g2819_i0 | PRJNA222400 | 2852 | 281 | 1.392241 | 3.91219721 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 9.11e-31 | NR | KAF4690990.1 | 32597 | g2819 | i0 | 68.1 | 14.9466192170819 | 94 | 28 | 99.3 | 2 | 3 | 281 | 62 | 154 | KAF4690990.1 V-type proton ATPase catalytic subunit A [Perkinsus olseni] | diamond | 4200 | 125 | 0.992 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 16944472 | 16944472 | PRJNA222400_P_NODE_3014_length_272_cov_1.609865_g2981_i0 | PRJNA222400 | 3014 | 272 | 1.609865 | 4.3788328 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 136 | 6.81e-39 | NR | KAF4646471.1 | 32597 | g2981 | i0 | 74.4 | 17.8676470588235 | 90 | 23 | 99.3 | 0 | 272 | 3 | 18 | 107 | KAF4646471.1 hypothetical protein FOZ61_005816, partial [Perkinsus olseni] | diamond | 4860 | 137 | 0.992700729927007 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 17634129 | 17634129 | PRJNA222400_P_NODE_1734_length_387_cov_1.076923_g1701_i0 | PRJNA222400 | 1734 | 387 | 1.076923 | 4.16769201 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 2.7799999999999992e-43 | NR | KAF4695297.1 | 32597 | g1701 | i0 | 59.4 | 3.96899224806202 | 128 | 52 | 99.2 | 0 | 386 | 3 | 364 | 491 | KAF4695297.1 hypothetical protein FOZ60_005162 [Perkinsus olseni] | diamond | 1536 | 159 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 20768739 | 20768739 | PRJNA222400_P_NODE_5377_length_193_cov_1.263889_g5344_i0 | PRJNA222400 | 5377 | 193 | 1.263889 | 2.43930577 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 2.69e-25 | NTclustered | gi|294891205|ref|XM_002773427.1| | 423536 | g5344 | i0 | 84.091 | 2.73575129533679 | 132 | 21 | 68 | 0 | 21 | 152 | 231 | 100 | Perkinsus marinus ATCC 50983 40S ribosomal protein S11, putative, mRNA | blastn | 528 | 128 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 26806973 | 26806973 | PRJNA222400_P_NODE_6901_length_171_cov_1.704918_g6868_i0 | PRJNA222400 | 6901 | 171 | 1.704918 | 2.91540978 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 95.1 | 1.18e-21 | NR | KAF4667652.1 | 32597 | g6868 | i0 | 76.9 | 4.70175438596491 | 52 | 12 | 91.2 | 0 | 14 | 169 | 155 | 206 | KAF4667652.1 hypothetical protein FOZ61_008040 [Perkinsus olseni] | diamond | 804 | 95.9 | 0.991657977059437 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29473668 | 29473668 | PRJNA222400_P_NODE_4830_length_202_cov_2.150327_g4797_i0 | PRJNA222400 | 4830 | 202 | 2.150327 | 4.34366054 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 2.03e-28 | NR | XP_002774056.1 | 423536 | g4797 | i0 | 82.1 | 0.995049504950495 | 67 | 12 | 99.5 | 0 | 201 | 1 | 218 | 284 | XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 201 | 113 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 30358837 | 30358837 | PRJNA222400_P_NODE_5732_length_187_cov_1.862319_g5699_i0 | PRJNA222400 | 5732 | 187 | 1.862319 | 3.48253653 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 74.7 | 9.21e-14 | NR | KAF4669068.1 | 330153 | g5699 | i0 | 65.6 | 1.94117647058824 | 61 | 21 | 97.9 | 0 | 3 | 185 | 1412 | 1472 | KAF4669068.1 hypothetical protein FOL47_002718 [Perkinsus chesapeaki] | diamond | 363 | 74.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 32855003 | 32855003 | PRJNA222400_P_NODE_1300_length_455_cov_1.756158_g1267_i0 | PRJNA222400 | 1300 | 455 | 1.756158 | 7.9905189 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 205 | 2.16e-64 | NR | XP_002778466.1 | 423536 | g1267 | i0 | 64.2 | 0.995604395604396 | 151 | 53 | 98.9 | 1 | 1 | 450 | 35 | 185 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 453 | 205 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus |
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);;