contig_metadata
8 rows where bioproject = "PRJNA788929", tax_kingdom = "Metazoa" and tax_phylum = "Porifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4597760 | 4597760 | PRJNA788929_P_NODE_40404_length_245_cov_10.441860_g39743_i0 | PRJNA788929 | 40404 | 245 | 10.44186 | 25.582557 | Hyrtios reticulatus | 1162751 | Porifera | other_Eukaryota | 139 | 1.6499999999999999e-28 | NTclustered | gi|512765404|gb|KC869642.1| | 1162751 | g39743 | i0 | 91.429 | 38.6571428571429 | 105 | 4 | 42 | 5 | 140 | 242 | 2047 | 2148 | Hyrtios reticulatus voucher NCI426 28S ribosomal RNA gene, partial sequence | blastn | 9471 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Thorectidae | Hyrtios | Hyrtios reticulatus | |
| 10143029 | 10143029 | PRJNA788929_P_NODE_8648_length_622_cov_25.655738_g7999_i0 | PRJNA788929 | 8648 | 622 | 25.655738 | 159.57869036 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 213 | 2.67e-50 | NTclustered | gi|2719038895|ref|XR_010393624.1| | 6063 | g7999 | i0 | 90.798 | 32.8938906752412 | 163 | 9 | 32 | 6 | 192 | 352 | 2167 | 2009 | PREDICTED: Halichondria panicea large subunit ribosomal RNA (LOC135332780), rRNA | blastn | 20460 | 215 | 0.990697674418605 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 17792066 | 17792066 | PRJNA788929_P_NODE_43134_length_238_cov_18.557576_g42473_i0 | PRJNA788929 | 43134 | 238 | 18.557576 | 44.16703088 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 115 | 2.69e-21 | NTclustered | gi|512765374|gb|KC869612.1| | 1183873 | g42473 | i0 | 85.217 | 47.3655462184874 | 115 | 13 | 48 | 4 | 34 | 147 | 2031 | 2142 | Stelletta fibrosa voucher P24 28S ribosomal RNA gene, partial sequence | blastn | 11273 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia fibrosa | |
| 26936306 | 26936306 | PRJNA788929_P_NODE_20922_length_356_cov_82.265018_g20262_i0 | PRJNA788929 | 20922 | 356 | 82.265018 | 292.86346408000003 | Metazoa | 33208 | Porifera | other_Eukaryota | 47.4 | 0.00276 | NR | XP_003382489.1 | 400682 | g20262 | i0 | 63.3 | 1.44101123595506 | 30 | 11 | 25.3 | 0 | 322 | 233 | 281 | 310 | XP_003382489.1 PREDICTED: receptor of activated protein C kinase 1-like [Amphimedon queenslandica] | diamond | 513 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 28317092 | 28317092 | PRJNA788929_P_NODE_4846_length_910_cov_60.862605_g4290_i0 | PRJNA788929 | 4846 | 910 | 60.862605 | 553.8497055 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 169 | 3.959999999999999e-48 | NR | XP_064394753.1 | 6063 | g4290 | i0 | 59.5 | 1.32197802197802 | 131 | 53 | 43.2 | 0 | 818 | 426 | 4 | 134 | XP_064394753.1 nuclear cap-binding protein subunit 2-like [Halichondria panicea] | diamond | 1203 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 28980253 | 28980253 | PRJNA788929_P_NODE_2948_length_1218_cov_48.311790_g2571_i0 | PRJNA788929 | 2948 | 1218 | 48.31179 | 588.4376022 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 189 | 1.6199999999999998e-48 | NR | XP_065192888.1 | 27933 | g2571 | i0 | 32.5 | 0.933497536945813 | 379 | 228 | 88.4 | 8 | 1123 | 47 | 3029 | 3399 | XP_065192888.1 spectrin alpha chain, non-erythrocytic 1-like [Sycon ciliatum] | diamond | 1137 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 32013559 | 32013559 | PRJNA788929_P_NODE_24458_length_324_cov_51.047809_g23797_i0 | PRJNA788929 | 24458 | 324 | 51.047809 | 165.39490116 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 73.2 | 2.11e-12 | NR | XP_062501809.1 | 121492 | g23797 | i0 | 38.7 | 1.4537037037037 | 75 | 46 | 69.4 | 0 | 25 | 249 | 1127 | 1201 | XP_062501809.1 uncharacterized protein LOC134178910 [Corticium candelabrum] | diamond | 471 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 32583189 | 32583189 | PRJNA788929_P_NODE_13519_length_465_cov_43.747449_g12862_i0 | PRJNA788929 | 13519 | 465 | 43.747449 | 203.42563785 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 69.7 | 1.5e-10 | NR | XP_065917509.1 | 196820 | g12862 | i0 | 32.9 | 0.941935483870968 | 146 | 79 | 84.5 | 6 | 8 | 400 | 462 | 603 | XP_065917509.1 syntaxin-binding protein 1-like isoform X2 [Dysidea avara] | diamond | 438 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara |
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);;