contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA1002570" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 152725 | 152725 | PRJNA1002570_P_NODE_9201_length_380_cov_2.644951_g9006_i0 | PRJNA1002570 | 9201 | 380 | 2.644951 | 10.0508138 | Arcyria sp. 'tenuissima' | 3129282 | Evosea | other_Eukaryota | 556 | 6.3e-154 | NTclustered | gi|2698738389|gb|PP491458.1| | 3129282 | g9006 | i0 | 93.005 | 1.67631578947368 | 386 | 19 | 99 | 5 | 1 | 379 | 3443 | 3827 | Arcyria sp. 'tenuissima' voucher sc32644 internal transcribed spacer region, partial sequence | blastn | 637 | 556 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Arcyria | Arcyria sp. 'tenuissima' | ||
| 6530630 | 6530630 | PRJNA1002570_P_NODE_35246_length_252_cov_2.581006_g35051_i0 | PRJNA1002570 | 35246 | 252 | 2.581006 | 6.50413512 | Fuligo septica | 159720 | Evosea | other_Eukaryota | 231 | 2.73e-56 | NTclustered | gi|37515398|emb|AJ584697.1| | 159720 | g35051 | i0 | 88 | 3.06746031746032 | 200 | 18 | 79 | 5 | 55 | 252 | 14003 | 13808 | Fuligo septica 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, isolate NY-1 | blastn | 773 | 231 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Fuligo | Fuligo septica | ||
| 6530860 | 6530860 | PRJNA1002570_P_NODE_7666_length_407_cov_3.221557_g7472_i0 | PRJNA1002570 | 7666 | 407 | 3.221557 | 13.11173699 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 501 | 3.23e-137 | NTclustered | gi|3221|emb|V01159.1| | 5791 | g7472 | i0 | 88.916 | 56.2653562653563 | 415 | 34 | 100 | 10 | 1 | 407 | 1939 | 1529 | Physarum polycephalum gene encoding 5.8S rRNA and 26S rRNA | blastn | 22900 | 501 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 19278041 | 19278041 | PRJNA1002570_P_NODE_35336_length_252_cov_1.888268_g35141_i0 | PRJNA1002570 | 35336 | 252 | 1.888268 | 4.75843536 | Cavostelium apophysatum | 435410 | Evosea | other_Eukaryota | 466 | 6.89e-127 | NTclustered | gi|260909290|gb|FJ766476.1| | 435410 | g35141 | i0 | 100 | 24.5119047619048 | 252 | 0 | 100 | 0 | 1 | 252 | 355 | 104 | Cavostelium apophysatum culture-collection ATCC:38567 clone 9 18S ribosomal RNA gene, partial sequence | blastn | 6177 | 466 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Cavostelium | Cavostelium apophysatum |
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);;