contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1101946" and tax_phylum = "Evosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4037991 | 4037991 | PRJNA1101946_S_NODE_224_length_777_cov_57.649725_g163_i0 | PRJNA1101946 | 224 | 777 | 57.649725 | 447.93836325 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 200 | 2.63e-46 | NTclustered | gi|290886108|gb|GU477644.1| | 472931 | g163 | i0 | 97.436 | 12.1441441441441 | 117 | 3 | 15 | 0 | 31 | 147 | 748 | 864 | Protostelium mycophagum strain HI04-85A-1b 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 5.8S ribosomal RNA gene, partial sequence | blastn | 9436 | 200 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 12965086 | 12965086 | PRJNA1101946_S_NODE_10511_length_242_cov_43.823834_g10412_i0 | PRJNA1101946 | 10511 | 242 | 43.823834 | 106.05367828 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 351 | 1.92e-92 | NTclustered | gi|262262902|gb|FJ766445.1| | 472931 | g10412 | i0 | 97.573 | 72.198347107438 | 206 | 3 | 85 | 2 | 26 | 230 | 1460 | 1664 | Protostelium mycophagum strain KA-T02-1 small subunit ribosomal RNA gene, partial sequence | blastn | 17472 | 351 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 16788447 | 16788447 | PRJNA1101946_S_NODE_8534_length_262_cov_13.338028_g8435_i0 | PRJNA1101946 | 8534 | 262 | 13.338028 | 34.94563336 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 414 | 2.65e-111 | NTclustered | gi|262262904|gb|FJ766447.1| | 472931 | g8435 | i0 | 95.094 | 42.8931297709924 | 265 | 10 | 100 | 2 | 1 | 262 | 332 | 68 | Protostelium mycophagum strain HI06-7A-1 small subunit ribosomal RNA gene, partial sequence | blastn | 11238 | 414 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 19337050 | 19337050 | PRJNA1101946_S_NODE_1076_length_474_cov_37.338824_g980_i0 | PRJNA1101946 | 1076 | 474 | 37.338824 | 176.98602576 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 540 | 8.07e-149 | NTclustered | gi|262262904|gb|FJ766447.1| | 472931 | g980 | i0 | 90.261 | 39.1434599156118 | 421 | 30 | 87 | 11 | 36 | 449 | 977 | 561 | Protostelium mycophagum strain HI06-7A-1 small subunit ribosomal RNA gene, partial sequence | blastn | 18554 | 540 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 24437130 | 24437130 | PRJNA1101946_S_NODE_10700_length_240_cov_86.209424_g10601_i0 | PRJNA1101946 | 10700 | 240 | 86.209424 | 206.9026176 | uncultured Variosea | 2777566 | Evosea | other_Eukaryota | 97.1 | 9.83e-16 | NTclustered | gi|2006880850|emb|HG995806.1| | 2777566 | g10601 | i0 | 89.474 | 0.433333333333333 | 76 | 8 | 32 | 0 | 165 | 240 | 1535 | 1610 | uncultured Variosea genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, clone 62615b63 | blastn | 104 | 97.1 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | uncultured Variosea | |||||
| 24437203 | 24437203 | PRJNA1101946_S_NODE_9680_length_250_cov_118.850746_g9581_i0 | PRJNA1101946 | 9680 | 250 | 118.850746 | 297.126865 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 350 | 7.17e-92 | NTclustered | gi|262262901|gb|FJ766444.1| | 472931 | g9581 | i0 | 94.667 | 48.336 | 225 | 12 | 90 | 0 | 26 | 250 | 1252 | 1476 | Protostelium mycophagum strain BRNFDF05-11A-3 small subunit ribosomal RNA gene, partial sequence | blastn | 12084 | 350 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum |
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);;