contig_metadata
7 rows where bioproject = "PRJNA493244", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1100156 | 1100156 | PRJNA493244_P_NODE_769501_length_524_cov_14.155508_g746925_i0 | PRJNA493244 | 769501 | 524 | 14.155508 | 74.17486192 | Metazoa | 33208 | Porifera | other_Eukaryota | 102 | 5.03e-17 | NTclustered | gi|2432606641|gb|OQ341438.1| | 1006814 | g746925 | i0 | 80.303 | 1.53053435114504 | 132 | 26 | 25 | 0 | 77 | 208 | 357 | 226 | Thenea schmidtii voucher PN83 large subunit ribosomal RNA gene, partial sequence | blastn | 802 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Theneidae | Thenea | Thenea schmidti | |
| 10661393 | 10661393 | PRJNA493244_P_NODE_845149_length_482_cov_2.104513_g822324_i0 | PRJNA493244 | 845149 | 482 | 2.104513 | 10.14375266 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 99 | 1.2e-20 | NR | CAI8026889.1 | 519541 | g822324 | i0 | 48.5 | 0.603734439834025 | 97 | 43 | 56 | 2 | 18 | 287 | 691 | 787 | CAI8026889.1 Carboxypeptidase A2 [Geodia barretti] | diamond | 291 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 13211544 | 13211544 | PRJNA493244_P_NODE_945891_length_431_cov_4.397297_g922863_i0 | PRJNA493244 | 945891 | 431 | 4.397297 | 18.95235007 | Aiolochroia crassa | 261677 | Porifera | other_Eukaryota | 159 | 2.38e-34 | NTclustered | gi|512765256|gb|KC869494.1| | 261677 | g922863 | i0 | 88.636 | 28.7308584686775 | 132 | 14 | 30 | 1 | 160 | 290 | 1337 | 1206 | Aiolochroia crassa voucher P04 28S ribosomal RNA gene, partial sequence | blastn | 12383 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Verongiida | Aplysinidae | Aiolochroia | Aiolochroia crassa | |
| 18306674 | 18306674 | PRJNA493244_P_NODE_1155375_length_344_cov_8.208481_g1132251_i0 | PRJNA493244 | 1155375 | 344 | 8.208481 | 28.23717464 | Pachastrella ovisternata | 1006801 | Porifera | other_Eukaryota | 75 | 6.94e-9 | NTclustered | gi|2802839332|emb|OZ181715.1| | 1006801 | g1132251 | i0 | 97.674 | 2.68023255813953 | 43 | 1 | 13 | 0 | 10 | 52 | 1893 | 1851 | Pachastrella ovisternata genome assembly, organelle: mitochondrion | blastn | 922 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Pachastrellidae | Pachastrella | Pachastrella ovisternata | |
| 19582585 | 19582585 | PRJNA493244_P_NODE_261656_length_1047_cov_9.998986_g247555_i0 | PRJNA493244 | 261656 | 1047 | 9.998986 | 104.68938342 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 290 | 2.7e-94 | NR | XP_065898664.1 | 196820 | g247555 | i0 | 62.3 | 2.98567335243553 | 215 | 81 | 61.6 | 0 | 983 | 339 | 1 | 215 | XP_065898664.1 large ribosomal subunit protein uL16-like [Dysidea avara] | diamond | 3126 | 290 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 29334509 | 29334509 | PRJNA493244_P_NODE_1749489_length_180_cov_6.084034_g1726364_i0 | PRJNA493244 | 1749489 | 180 | 6.084034 | 10.9512612 | Homosclerophorida | 81000 | Porifera | other_Eukaryota | 74.3 | 1.2e-13 | NR | XP_062504659.1 | 121492 | g1726364 | i0 | 56 | 6.66666666666667 | 50 | 22 | 83.3 | 0 | 174 | 25 | 979 | 1028 | XP_062504659.1 uncharacterized protein LOC134181402 isoform X2 [Corticium candelabrum] | diamond | 1200 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 31419577 | 31419577 | PRJNA493244_P_NODE_1348916_length_282_cov_4.416290_g1325792_i0 | PRJNA493244 | 1348916 | 282 | 4.41629 | 12.4539378 | root | 1 | Root_unresolved | Root_unresolved | 95.1 | 2.28e-20 | NR | XP_065835600.1 | 121494 | g1325792 | i0 | 52.9 | 3.64893617021277 | 87 | 39 | 90.4 | 1 | 8 | 262 | 602 | 688 | XP_065835600.1 uncharacterized protein [Oscarella lobularis] | diamond | 1029 | 95.5 | 0.995811518324607 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis |
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);;