contig_metadata
6 rows where bioproject = "PRJNA760976", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 742331 | 742331 | PRJNA760976_P_NODE_24341_length_325_cov_2.861111_g24020_i0 | PRJNA760976 | 24341 | 325 | 2.861111 | 9.29861075 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 155 | 1.96e-41 | NR | KAF4658562.1 | 32597 | g24020 | i0 | 75.8 | 6.41538461538462 | 99 | 24 | 91.4 | 0 | 27 | 323 | 979 | 1077 | KAF4658562.1 hypothetical protein FOL46_006904 [Perkinsus olseni] | diamond | 2085 | 156 | 0.993589743589744 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 7582993 | 7582993 | PRJNA760976_P_NODE_14706_length_389_cov_1.155063_g14386_i0 | PRJNA760976 | 14706 | 389 | 1.155063 | 4.49319507 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 5.71e-60 | NTclustered | gi|294925483|ref|XM_002778887.1| | 423536 | g14386 | i0 | 82.624 | 70.8097686375321 | 282 | 43 | 72 | 5 | 1 | 279 | 156 | 434 | Perkinsus marinus ATCC 50983 ribosomal protein S23, putative, mRNA | blastn | 27545 | 246 | 0.991869918699187 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 9670799 | 9670799 | PRJNA760976_P_NODE_3548_length_692_cov_2.819063_g3245_i0 | PRJNA760976 | 3548 | 692 | 2.819063 | 19.50791596 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 2.79e-100 | NTclustered | gi|294890662|ref|XM_002773206.1| | 423536 | g3245 | i0 | 77.108 | 73.4609826589595 | 664 | 147 | 96 | 5 | 32 | 692 | 693 | 32 | Perkinsus marinus ATCC 50983 60S ribosomal protein L10A-2, putative, mRNA | blastn | 50835 | 379 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 12221966 | 12221966 | PRJNA760976_P_NODE_18390_length_359_cov_1.297203_g18069_i0 | PRJNA760976 | 18390 | 359 | 1.297203 | 4.65695877 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 5.46e-60 | NR | XP_002768542.1 | 423536 | g18069 | i0 | 77.1 | 13.7715877437326 | 118 | 27 | 98.6 | 0 | 356 | 3 | 1 | 118 | XP_002768542.1 ribosomal protein S23, putative [Perkinsus marinus ATCC 50983] | diamond | 4944 | 191 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 32676703 | 32676703 | PRJNA760976_P_NODE_43220_length_263_cov_1.200000_g42899_i0 | PRJNA760976 | 43220 | 263 | 1.2 | 3.156 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 72.8 | 3.96e-13 | NR | XP_002776299.1 | 423536 | g42899 | i0 | 68.8 | 0.547528517110266 | 48 | 15 | 54.8 | 0 | 261 | 118 | 203 | 250 | XP_002776299.1 proteasome subunit alpha1, putative [Perkinsus marinus ATCC 50983] | diamond | 144 | 72.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 32771239 | 32771239 | PRJNA760976_P_NODE_27920_length_310_cov_1.721519_g27599_i0 | PRJNA760976 | 27920 | 310 | 1.721519 | 5.3367089 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 1.05e-20 | NR | KAF4685235.1 | 32597 | g27599 | i0 | 53 | 1.27741935483871 | 66 | 31 | 63.9 | 0 | 4 | 201 | 59 | 124 | KAF4685235.1 hypothetical protein FOZ60_006752 [Perkinsus olseni] | diamond | 396 | 90.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni |
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);;